GL Reconciliation

Marlin GTX enables reconciliation of the GL Bank Account balance against the Cashbook Balance either after an End of Day or during trading by using calculated figures and report references.

After an End of Day (Recommended Method)

For an easy & accurate reconciliation of the GL Bank account balance (e.g. A/C 60005) against the Bank Reconciliation (Cashbook balance) you should ensure an End of Day and Banking Register has been performed.

This will ensure all relevant postings have been made and simplify the reconciliation process significantly. Marlin audits and validates the Subledger against the General Ledger and will produce a ‘Control Total Error’ should the system not balance.

Run the End of Day process and select the Control Totals Reconciliation tab on the report:

• If the End of Day process has already been completed, select Reports > Print Register Reports > End of Day Register from the menu, then select the most recent register.
• If the report does not include the Control Totals Reconciliation tab, first select System > Options from the menu, select the End of Day Report tab, tick the Control Totals Reconciliation option in the Generate column, then Save)

Scroll down to page 2 and the Calculated GL Bank Balance amount and Calculated Cashbook Balance amount should match.

During Trading (Advanced Method)

Reconciliation of the GL Bank Account can be performed after an End of Day with the user making reference to the Undeposited Cash and Cheque balance that can be found via the Banking Enquiry ‘Total Banking’ figure - i.e. This figure makes up the Cash & Cheque portion which has been posted to the GL but has not yet to hit the Bank Rec (cashbook balance).

Reconciliation during trading periods whereby an ‘End of Period’ or ‘Banking’ has not been completed is much more complex and the user must have a comprehensive understanding of how the Marlin GL can be influenced by the various types of transactions.

For example:

• Marlin can post directly to the Bank GL via a journal / cashbook entry.
• Marlin summarises file/subledger transactions made during a period and posts a consolidated entry to the GL at End of Day.
• GL movements and their corresponding cash transactions may not hit the Bank Rec until a Bank Register is performed.
  • Direct EFT Payments will hit the Bank Rec automatically
  • Cheque Payments will hit the bank rec automatically
  • Cash payments / Cash receipts are tied up in undeposited funds until a Bank Register is performed.
  • EFT receipts via the EFTPOS Terminal are held as undeposited until an EOD is performed.

Performing the reconciliation during trading requires some calculations and we therefore recommend that you use the simpler End of Day method above rather than the manual method below.

Account Enquiry – Bank

Perform an account enquiry on your bank account (Main > Accounts > Manage Chart of Accounts).

Note the Current Year Balance.

Cashbook Balance

Open your Cashbook (Main > Data Entry > Cashbook or Bank Reconciliation).

Note the Cashbook Balance.

Banking Enquiry

Run a Banking Enquiry (Main > Enquiries > Banking)

Reconciliation

These calculations should produce the same results as if you ran the End of Day right now.