#1 Importing and Reconciliation (Balanced)

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

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

Import the Bank and G/L as usual.

Note - Import the OutStandingChecklist into the G/L side.

Matching – Ok to just have the default rules enabled (Check to Check, Void and Amount)

Attempt to run a reconciliation report using the following:

 

Problem (at 7/30/2026):
The Outstanding check list has records in it from Feb 2027.
The Bank and G/L file has records in it from March 2027.
We want to reconcile for the period March 2027, but are unable to enter beginning balances for March 2027.

The system assumes that the period with the earliest records (Feb 2027) will be the first period we are reconciling and only provides us text boxes to enter beginning and ending balances for that period.  

Please display/enable beginning balance boxes whenever the Wizard is run.

When completed, the Reconciliation report should be in balance.

[End of 'In Balance']

#2 Importing and Reconciliation (Out of Balance)

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

***Note: Important - We are now using a different Outstanding Checklist file***

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.