4 Things You Should Know about the Bank Reconciliation Report

2 minute read time.

The (RAPPRO) Bank Reconciliation report is available to print for a specific bank. Let's explore 4 things you should know about the Bank Reconciliation report.

First, there are various ways to access the report. The first is from A/P-A/R accounting, Bank transaction, Bank reconciliation. The second is from the reports menu group of Treasury. The third is from Reports, Reports, in the report code type RAPPRO.

X3 is robust and can have parameter(s) that control the behavior throughout the system. With the Bank Reconciliation report the second thing to know is the SNSBNQ parameter controls how the sign of the postings on the statement in the bank statement reconciliation table are displayed.

  • Yes: the postings on the statement are displayed with the bank sign.
  • No: the postings on the statement are displayed with the accounting sign

Example: SNSBNQ=YES. This means the report will display Debits and Credits from the Bank perspective.

Notice the $100,000.00 is in the Credit column. This means their is $100K in the bank account and is displayed from the Bank's perspective.

Example: SNSBNQ=NO. This means the report is will not look like a Debit or Credit from a Bank perspective but will display from a Ledger perspective.

Notice the $100,000.00 in the Debit column. This means their is still $100K in the bank account, it is displayed from a Ledger perspective.

The third thing to know is bank reconciliation report needs to be read from two perspectives; the bank's perspective and the company's perspective. 

The report header is always written from the "bank's perspective". This means it does not matter what SNSBNQ is set to, the header is always the bank information. 

  • The bank balance at the requested date (it is the balance of the last bank statement prior to the requested date).
  • The detailed bank entries that are not reconciled.
  • The total of the bank entries that are not posted. This total is the sum of the entries that are not reconciled.
  • The bank total. This total is the sum of the reconciled bank entries.

The entries below are always written from the "company perspective" no matter the SNSBNQ.

  • The detailed accounting entries that are not reconciled.
  • A total of the accounting entries that are not reconciled.

One fourth thing to note and is very important. If the SNSBNQ is changed from Yes to No, or from No to Yes, the SQL tables are not retroactive. The bank statement entries would need to be re-imported or re-entered. 

What do you find most helpful about the Bank Reconciliation report?

If you like this blog, select Like and follow up with a comment regarding additional topics you would like me to write about regarding X3.