Please make sure that you are connected to a SQL (either SQL Express or SQL Server) database before proceeding.

#1 Importing and Reconciliation (Balanced)
Please create a new account (for reference call it ‘Test1RecBalanced’ or similar) within the system and import:

You'll need (click on each to download):
March_Bank.xlsx
March_GL.xlsx
OutStandingChecklist.xlsx

Import the files above into the software.

Matching – You won't need to set/create any matching rules.  
Note: You will have 2 unmatched bank records and 5 unmatched G/L records.

Run a reconciliation report using the following:

#2 Importing and Reconciliation (Out of Balance)

Please create a new account (for reference call it ‘Test1RecOutofBalance’ or similar) within the system and import:

You'll need (click on each to download):
OutStandingChecklist-MissingaCheck.xlsx (note: different filename)
March_Bank.xlsx (same as #1)
March_GL.xlsx (same as #1)
Import the files above into the software.

Matching – You will not need to set/create any matching rules.  

Run a reconciliation report AND accept the recommended entry. 

Tip: The difference between the earlier Outstanding check list and the OutStandingChecklist-MissingaCheck.xlsx is that the OutStandingChecklist-MissingaCheck.xlsx is missing a check for $2,001.59.