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.

Free Trial
Please, insert a valid email address.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

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

Watch this Template Video Tutorial

Free Trial
Please, insert a valid email address
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

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

Get 2 Months OFF
One Challenge Plan
Access to 1 spreadsheet
Access up to 10 presentations
Free updates
Activation in up to 10 computers
Free 1h lesson
Premium support
From
USD
7,90
to
USD6,58
/month
billed as USD79 annually
Start 7 Days Free Trial
*cancel anytime, no hidden costs
Improve Your Department Plan
Select up to 5 spreadsheets
Access to all presentations available (+80)
Free updates
Activation in up to 10 computers
Unlimited Usage Lessons
Ask for new templates at feedback.luztemplates.com
Premium support
Less than USD0,05 per template
From
USD
11,90
to
USD9,92
/month
billed as USD119 annually
Start 7 Days Free Trial
*cancel anytime, no hidden costs
Full Organization Plan
Access to all spreadsheets available (+120)
Access to all presentations available (+80)
Free updates
Activation in up to 10 computers
Priority on new templates at feedback.luztemplates.com
Unlimited Usage Lessons
Premium Support
Less than USD0,01 per template
From
USD
15,90
to
USD13,25
/month
billed as USD159 annually
Start 7 Days Free Trial
*cancel anytime, no hidden costs
One Challenge Plan
Access to 1 spreadsheet
Access up to 10 presentations
Free updates
Activation in up to 10 computers
Free 1h lesson
Premium support
USD7,90
/month
Start 7 Days Free Trial
*cancel anytime, no hidden costs
Improve Your Department Plan
Select up to 5 spreadsheets
Access to all presentations available (+80)
Free updates
Activation in up to 10 computers
Unlimited Usage Lessons
Ask for new templates at feedback.luztemplates.com
Premium support
Less than USD0,05 per template
USD11,90
/month
Start 7 Days Free Trial
*cancel anytime, no hidden costs
Full Organization Plan
Access to all spreadsheets available (+120)
Access to all presentations available (+80)
Free updates
Activation in up to 10 computers
Priority on new templates at feedback.luztemplates.com
Unlimited Usage Lessons
Premium Support
Less than USD0,01 per template
USD15,90
/month
Start 7 Days Free Trial
*cancel anytime, no hidden costs