#1 Update your software with the latest release.
Before proceeding, make sure that you have the latest release (at least build 2210).
From within the software click on Help > Software. Allow the system to install the update and it will exit. Start the software afterwards.
After restarting the software, enter into an account. Confirm you are on build 2210 (Help > About).
Note: If you are not on build 2210 (or later), stop and contact us.
[Terri: You do not need to take screen shots of the import process - unless there is an issue. Feel free to start taking screen shots when you attempt to reconcile, and your steps to get back into balance.]
#2 Working with Out of Balance data for the current period.
Please create a new account to work in (File > New).
You'll need (click on each to download):
Bank_March2.xlsx
GL_March2.xlsx
OutstandingChecklist2.xlsx
March_Bank_BankStmt.pdf
Import the Bank_March2.xlsx for the bank, and GL_March2.xlsx for the G/L.
Also, import the OutstandingChecklist2.xlsx.
Run a Reconciliation Report for March 2027 using the beginning and ending balances below
However, you will see that you are out of balance for the Bank current period and cannot proceed.
Your Beginning Balance + Net Activity does not equal your Ending Balance.
Use the built-in tools/options of the Reconciliation Report to help find the out of balance by comparing to March_Bank_BankStmt.pdf.
Once you add the missing bank record, complete the Reconciliation Report.
[Terri: Hopefully step 3 will be uneventful. No need for screen shots unless an issue.]
#3 Importing subsequent period’s data (April and May 2027)
Using the same account you created for the step above, import April's data.
April and May's data may be found in the two files (click to download):
Bank_Following_Months.xlsx
GL_Following_Months.xlsx
Run a Reconciliation Report for April 2027 using the beginning and ending balances below.
Then import May's data and run the Reconciliation Report for May 2027.
[Terri: Please take screen shots of this entire step. Please note whether the record is successfully deleted.]
#4 Deleting a transaction from a reconciled period
Please delete the G/L record dated 4/30/2027 for $7,036.54 deposit (it is a duplicate entry from earlier in the month and unmatched).
After deleting the record, please re-reconcile April and May using the balances below:
