Sage V12 - bank reconciliation - Grouped transactoins

[Jaxer]

I've just started cleaning up the bank account by going through the bank rec screen in V12. I've now discovered that all transactions entered on the same date using the same reference (eg. BACS, or STO) are being shown as cumulative totals in the bank rec. screen even through they were entered separately.

I've disabled "Smart Totals" and "Group Transactions" in the Bank Module preferences but this hasn't helped. Is there any way of getting Sage to show these things line by line?

I don't if it's clear but as an example, I might have 4 or 5 direct debit or BACS payments going out of the bank on any particular day. I tend to use the reference field to denote either the cheque number where paid by chq, or a standard "BACS" or "STO" for standing order/BACS payments etc. I've been told that Sage automatically groups by the reference field for same date transactoins so I would have to enter "BACS1", "BACS2" to differentiate for several payments going out on the same day.

This would be very irrititating to me especially as I have so many transactions going out daily to have to enter additional text instead of just using "F6" to replicate the box above.

How do other people enter STO/BACS/DD payments in this kind of scenario? Would be grateful for any pointers.

[brucedenney]

Blanks are not consolidated.

Consecutive entries with the same, date, and reference are taken to be splits within one transaction.

[Jaxer]

Thanks for the response. I suppose leaving it blank is an option, but is there any alternative if you want to be able to see the method of payment (ie. BACS/chq no. etc). I'm reluctant to just leave it blank because that could mean that you're never sure if it was something omiited by mistake later on.

[chiquita]

Hi

What I normally do is add the supplier or customer name after the ref, i.e. BACS BAILEY or 00056 JAMES so that it doesn't group them altogether. This way you can see the method of payment and also the name of the person or company it relates to. Hope this helps

[welshal]

Hi.

I'm relatively new to Sage, but haven't been able to find much on this issue.

When coming to the bank reconciliations and matching bank entries, I find that some entries end up being grouped whilst others are not.

Can you please help me:
1. Understand the grouping; what are the criteria for grouping.
2. Suggest solutions for ending/avoiding it.

We currently process around 100 invoices per day, split around 80% Card, 10% Cheque and 10% Cash.

We use the reference field for identifying each, which are paid into separate bank accounts in Sage (1200, 1204 and 1230)

When it comes time to reconcile, I'm having a hard time locating card transactions to match against the bank statement!.

Any help would be gratefully appreciated.

Alex.

[brucedenney]

Grouping items on bank rec rules:-

Items are grouped together if ....

They are consecutive
They are on the same date
They are on the same bank account
They have the same reference

If your transactions meet these rules they should be grouped.

(It goes without saying that you have to select the grouping of bank transactions option in company preferences)