Small and medium business | Business Central, N...

Reconcile Bank statement , Using 1 G/L for 2 bank accounts

(0) Share

Report

Posted on by Amninder

I am doing first Bank reconciliation in Business Central.

We set everything up already, bank Accounts , Posting groups, G/L's and Now I came to know that Each Bank Account must have a unique Bank Posting Group associated with it.

If you associate more than one Bank Account to one Bank Posting Group, you will not be able to reconcile the G/L to the bank statements.

Is there a way around for this issue ?

I have the same question (0)

All responses (6)

Answers (0)

Amninder 20 on at

Like (0)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

HI Kemi

Although the entries in reconciliation page are pulled for only one bank account but the G/L balance pulls up for the all entries (including other bank).

Was this reply helpful? Yes No
Suggested answer

KemiBello 105 on at

Like (0)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

You can create Two separate bank account in business central and then create two separate Bank Account Posting group aimed at the same G/L account. When ever you are making an entry with account use that as the balancing account. If you are utilizing the bank reconciliation page in BC to perform bank reconciliations then the entries will be pulled from the bank ledger based on bank account not based on GL account. so you should be able to complete this with now problem.

Was this reply helpful? Yes No
Amninder 20 on at

Like (0)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

Hi Josh

Thanks for your recommendation, I understood that It can give me a balance based on dimension in the G/L

however I am still not sure how I could make it match in reconciliation report as there is still a difference and I can not complete the reconciliation in Business central.

Any suggestions?

Was this reply helpful? Yes No
JAngle 113 on at

Like (0)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

Assign a dimension to the bank account so that it feeds through to transactions. Then you can filter at g/l level based on that dimension to give you corresponding totals

Was this reply helpful? Yes No
Amninder 20 on at

Like (0)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

Hi Bilal

Thanks for your reply.

I am sorry I couldnt explain well.

I understand we can make 2 posting groups but if both of the posting groups assigned to 1 G/L , then how can we do bank reconciliation.

I tried to reconcile but G/L balance doesn't match with the Bank. Because Same G/L is used for Bank A & Bank B.

Any way around for this !

Was this reply helpful? Yes No
Bilal Haider 391 on at

Like (1)

Report

RE: Reconcile Bank statement , Using 1 G/L for 2 bank accounts

Hi,

I cannot see any issue in this. You ca create two different Bank Posting Groups for two different bank accounts and then assign one G/L account to both Bank Account Posting group.

Was this reply helpful? Yes No