No items found.
No items found.
Back

Bank Reconciliation Excel Spreadsheet Template

Transform your bank's OFX file into CSV to be used in macros that automatically reconcile.

Bank Reconciliation Excel Spreadsheet Template

Financial Movements
Area for you to register your financial launches that will be compared with the values ​​of your bank statement. You can copy and paste data from other worksheets.

Bank statement
Area for automatic registration of your bank statement. The spreadsheet has macros to convert an OFX file (usually used by banks) to CSV and also to read the CSV and get the data automatically.

Macro for conversion of OFX files into CSV
Most banks use OFX files when you export the information in your statement. This macro serves to transform this file into a CSV version of it (Excel-friendly), which will be used later in the worksheet

Macro to load CSV files automatically
Do not waste your time adding all your bank statement data to the spreadsheet, this macro does this for you automatically after choosing the CSV file with your bank information.

Button for Automatic Bank Reconciliation
With your postings and extracts filled, just push a button to see your bank reconciliation. The colors already inform you if there is a release that has not been reconciled.

Adjustment of uncontruded postings
If bank reconciliation is not correct, the spreadsheet has macros for adding lines automatically to make it easier to organize your postings

Bank Reconciliation Dashboard
Follow a control panel with the main information, indicators and graphs of your bank reconciliation

Bank Reconciliation Excel Spreadsheet Template

Congratulations!

You have started the Trial for Bank Reconciliation Excel Spreadsheet Template

We want to make sure that you have a good experience trying our templates

Please, if you have any problems or questions, don’t hesitate to contact us through:

Why LUZ Templates?

Unlimited Downloads

Freedom to test and share it with your team

Over 200 Templates

Templates that you make more productive in any task

Easy Cancellation

You can stop your subscription at any time. No questions asked.

Our plans

Monthly plan
USD 9,90
/month
Access to 150+ worksheets
Access to 80+ presentations
New products every month
Premium support
Cancel whenever you want
New free updates
License for up to 10 computers
Start Free Trial
Annual plan
USD 99
/year
Access to 150+ worksheets
Access to 80+ presentations
New products every month
Premium support
Cancel whenever you want
New free updates
License for up to 10 computers
Save 2 months!
Start Free Trial