Pastel Xpress-Consolidated entry for receipts not reflecting consolidated amount in Customer Account

[EllieR]

Hi All,

I am trying to reconcile a customer account.
In doing so, I went back to the physical Bank statements and compared it to entries on the cash book for a specific month to verify that it was reconciled correctly.
I have found that there were 2 payments received from the Customer in 1 month.
When this was processed on the cashbook, it shows a line item that says "Consolidated Entry" to the Customer account with the cumulative amount received.
But when I go to the Customer account it does not show that cumulative amount. It only shows the 1 amount received.

Why would this happen and how to do rectify this?

PS. this all happened in the last financial year.

[Neville Bailey]

Run the following report for the month in which the cashbook shows the consolidated amount: View...General Ledger...Transactions...Entry Type Details, and then select the Entry Type (in the Start and End fields) for that cashbook's receipts.

The report should give a breakdown of the consolidated amount, by its reference.

I'm guessing that one of the amounts was allocated to the correct customer account, and the other amount to a different account, which is why you only see one amount on that customer account. The other possibility is that the other amount is reflecting on the correct customer account, but in a different period, and the common reference for the two amounts has grouped them together in one of the periods.

[EllieR]

Hi Neville,

Thank you!
That was exactly the case!

Why is it that Xpress "consolidates" the entries on the cashbook module even though it was allocated to 2 different customer accounts?

[Neville Bailey]

Pastel always consolidates entries that have a common reference, irrespective of the dates of the entries.

[EllieR]

okay.

Thanks again!