Bank Reconciliation Worksheet in Excel 4.0

CAD $55.00

In stock

  • Fully Editable
  • Compatible with all Excel versions
  • Instant Download
  • One-time charge (no monthly fees)

Download DEMO

Compare

CAD $55.00

Description

Download DEMO

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

0/5 (0 Reviews)
Download DEMO

Reviews (0)

Submit your review

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Reviews

There are no reviews yet.

Store Policies

Inquiries

General Inquiries

There are no inquiries yet.

Main Menu

Bank Reconciliation Worksheet in Excel 4.0

CAD $55.00

Add to Cart