Core Reports: Setting Up the Check Register

To begin using the Check Register and to set up the Bank Reconciliation, prepare the following information: 

• The check register balance from the checkbook as of one day prior to the start date. Example: If starting the check register 1/1/21, the ending balance from 12/31/20.
• The ending balance from the prior month's Bank Statement. i.e.: The Bank Statement from 12/31/xx.
• A list of all outstanding items that have not cleared the bank as of the bank statement’s date. Include all deposits, checks and withdrawals. Note: Deposits can include EFT (Electronic Fund Transfer) Deposits not yet cleared the bank, including agency processed credit card transactions (CC Merchant). Withdrawals can include EFT Withdrawals not yet cleared the bank, including scheduled EFT expense withdrawals. 

A list of all outstanding items that have not cleared the bank as of the bank statement’s date. Include all deposits, checks and withdrawals. Note: Deposits can include EFT (Electronic Fund Transfer) Deposits not yet cleared the bank, including agency processed credit card transactions (CC Merchant). Withdrawals can include EFT Withdrawals not yet cleared the bank, including scheduled EFT expense withdrawals. 

To help gather the information needed , complete the information below: 

Bank Statement Ending Balance         _____________________________  

Total of Outstanding Checks             - _____________________________

Total of Outstanding Withdrawals   - _____________________________  

Total of Outstanding Deposits         + _____________________________

Ending Balance                                  = _____________________________

1. Click Reports|Core|Check Register. 
2. In the From and To fields, enter the date one day prior to the start date. (e.g., From: 12/31/11, To: 12/31/11) 
3. The Bank Acct field should be the corresponding bank account number (1, 2, 3, etc.). To change the default, type in the new number, or click the arrow next to the field to see the list.
4. Leave Bank Reconciliation field to the default set to All. Click Preview to process. Note the Ending Balance at the end of the report.
5. To zero out the Ending Balance enter a Withdrawal (Payments|Withdrawal) if the amount is positive or enter a Deposit (Payments|Deposit) if the amount is negative.

Note: The date of the Deposit or Withdrawal is one day prior to the start date (or one day prior to the statement end date). In the Remark field type, “To zero out acct.” 

6. Enter the Ending Balance from the bank statement by creating a Deposit if the amount is positive or a Withdrawal if the amount is negative. The date of the entry should be one day prior to the start date. In the Remark field, type “Bank Statement Balance.”
7. Next, click Payment|Reconciliation|Bank Reconciliation.
8. Click Clearing Date and enter the date one day prior to the start date.
9. Leave Stmt Ending Balance
10. Click OK to process.
11. Trams shows a list of payment items (Deposits, Withdrawals and Checks). Click Clear All to mark all items as cleared. Click OK to save.
12. Trams prompts, “(Number) Payment(s) Will be Marked Cleared and (Number) Payment(s) Will be Marked Uncleared. Continue? Yes or No.” Click YES.
13. Next, enter the list of all outstanding deposits, withdrawals and checks under Payments with actual dates as long as they are at least one day prior to the start-up date. DO NOT CREATE A JOURNAL ENTRY WHEN PROMPTED. 
14. Once all outstanding items are entered, click Reports|Core|Check Register and print as of one day prior to the start date, with Bank Reconciliation set to All. Verify that the checkbook balance is correct.