|Home > Excel Business Solutions > Business Finance > Financial Accounting > Bank Account Reconciliation||Share|
Excel Bank Account Reconciliation
Rate this solution:(3.7/5 from 4 votes)
The Excel Bank Account Reconciliation template can be used as an cash accounting book and allowing the preparation of your bank reconciliation at the press of a button. |
The Excel Bank Account Reconciliation template comprises the following:
Having set up the details on the last two Bank Account Reconciliation templates you are then ready to start entering your cash book detail into the 12 receipts and 12 payments sheets. Any sheet that already contains a total line can either have lines inserted above that line, or better still, you should delete the totals line. At any time you can automatically have a totals line added just by clicking on the button at the top of the sheet - the software will insert the formulae for however many columns you have used (which can vary from sheet to sheet).
On the 12 sheets you must not change the format of columns A - E:
At any time you can create the bank reconciliation simply by pressing the button on the first worksheet, and entering the current bank balance.
You should observe these limitations for using the Bank Account Reconciliation workbook:
1. Do not change the worksheet tab names as supplied in the file. You can add your own new worksheets though this is not recommended. You can move the sheets around e.g. put all the 12 receipts sheets together, and similarly the payments sheets.
2. Do not alter the format of the worksheets except you may use columns F onwards on the 12 receipt and 12 payments sheets as you wish.
3. The 12 receipts and 12 payments sheets are limited to 32,750 usable rows. If you use more then the automatic Bank Account Reconciliation will not work properly.
Related Excel Solutions for Bank Account ReconciliationCash Flow ForecastingBusiness Planning Budget PlanningBusiness Planning General LedgerFinancial Accounting Debt ManagementFinancial Accounting Web Reporting ToolPresentation and Reporting Accounts Receivable TemplateFinancial Accounting
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity