You can download another Microsoft Excel reconciliation template from Samplewords that may be a little simpler for you to use.
To use this reconciliation template, all you have to do is click the link to download. When the file opens it is in read only mode, so you will have to save the file to a new name when you get started.
The file works a lot like the first template you saw. You enter the month the reconciliation is for, and the date of your statement. After that, type in your statement ending balance.
After that, you enter the deposits made that do not appear on your statement or that have been made after the statement date. When that is complete, you list all the checks and other debits made to your account since that time. The Microsoft Excel reconciliation template will then automatically calculate your balance. You then compare that result with the balance in your register and make adjustments as necessary.
These Microsoft Excel reconciliation templates are two methods to help you get a handle on your finances.
Image Credits: Screenshots taken by Bruce Tyson