Archive

Posts Tagged ‘cash’

Consolidate Payment Record in Bank Reconciliation

October 15th, 2011 No comments

When doing an AR payment posting, if there are multiple payments from same customer or differ customers, the cash account entry will be consolidated into single one.  So in Bank Reconciliation, there will be single total line cash record, instead of check by check.

For example,

1. Create Payment
Customer 1 : Cheque Amount = USD 200 ; Date :1 December 2010; Bank : BK1
Customer 2: Cheque Amount = USD 300 ; Date : 2 December 2010; Bank : BK1
2. A/R Payment Posting
3. GL –> Journal Posting
4. Bank Reconciliation
Transaction appear as 1 line ; Amount USD500 ; Date : 1 Dec 2010

If you do not want an A/R payment (Adjust, Check, Wire) or a returned check (check entered as a negative amount) included in a summarized Bank Reconciliation record, you will have to do separate AR payment postings.

When you have a single check posted, the customer number, check number, and customer name will be seen in the Bank Reconciliation form.

When you have more than one check posted, for different customers, a "summary" deposit is created. Since there is more than one customer here, the customer number, customer name, and check cannot be specified in the one line bank reconciliation "Deposit".  If you want to see specifics for each check, then you have to post them separately, one at a time.

The detailed payment information which is used to calculate one of these summarized bank reconciliation records can be obtained by looking at the A/R Distribution Journal.