Reconciling bank accounts with bank statements
About clearing outstanding bank transactions
Matching Bank Feed transactions with Sage 100 Contractor transactions
About incorrect statement beginning balances
Important! When your cursor is in the grid area of the 1-5 Bank Reconciliation window, no function keys except F1 are available. You may launch the calculator (F3) after displaying the 1-5 Bank Reconciliation window by clicking in the Statement Cutoff Date text box, and then pressing F3.
The 1-5 Bank Reconciliation window, similar to a check register, displays transactions that have not cleared. As you compare the bank statement to the transactions in 1-5 Bank Reconciliation, clear the transactions listed on the bank statement.
You can display transactions recorded up to a specific date. In the Statement Cutoff Date box, enter the statement ending date to display all transactions through the specified date. Sage 100 Contractor does not display transactions entered after the indicated date.
Sage 100 Contractor displays transactions in transaction number order. If a check number falls out of numbered sequence, Sage 100 Contractor displays an asterisk (*) next to the transaction number.
The Statement Beginning Balance box displays the balance as of the last reconciliation. The amount in the Statement Beginning Balance box does not change until you have cleared transactions and saved the changes.
When you display records for a checking account, the Statement Ending Balance box displays the balance as of the last reconciliation. As you change the status of transactions, the amount in the Statement Ending Balance box changes. A P displayed with a transaction in the Record# column indicates that the transaction is from a prior year.
After clearing the transactions, the ending balance in 1-5 Bank Reconciliation should match the ending balance of your bank statement. After you reconcile the account with the statement and save the changes, Sage 100 Contractor rolls the amount in the Statement Ending Balance box to the Statement Beginning Balance box.
Sage Bank Feeds enables you to download transaction records from your bank and let Sage 100 Contractor automatically match transactions from your bank with transactions entered in your Sage 100 Contractor system. If you download transactions for the same period as your bank statement, you essentially have an electronic copy of your bank statement.)
This automated matching process removes much of the tedium of bank reconciliation and ensures that your company records match the transactions processed by your bank.
For more information, see About Sage Bank Feeds.
After clearing transactions, save the changes. Items you have cleared no longer appear in the 1-5 Bank Reconciliation window.
Sage 100 Contractor lets you save a trial reconciliation that is only partially completed. You can then return later to finish the reconciliation.
Note: When saving a reconciliation as Final, the records are updated permanently. You cannot undo a reconciliation once you have clicked [Final].
Tip: The default location when saving the Bank Reconciliation Report as a PDF file is \\Sage100Con\Company\[your company]\Files\Reports. You can save it to a different location.