Topic: Bank account balance is not the same in trial balance.

Why bank account balance is not the same in trial balance and bank account inquiry balance and who should be considered correct?
And what is the solution?

Re: Bank account balance is not the same in trial balance.

Reconcile it with your bank statement. And which will eventually help you to Sort out the issue in unnecessary entires.

3 (edited by msuhail197 03/25/2021 03:01:52 am)

Re: Bank account balance is not the same in trial balance.

I thank you for wasting your precious time and answering me.
My problem is that the balance of the checking bank account and the balance of the same bank account in trial balance is not same both in FrontAccounting, how can I solve it?

Re: Bank account balance is not the same in trial balance.

Check if there are any un-reconciled entries in your bank account that is not there in your trial balance and vice-versa and pass necessary Journal entriess.

Re: Bank account balance is not the same in trial balance.

You took your precious time and replied to me, I am grateful to you. I see it and act on it۔

6 (edited by albertolima 05/07/2021 12:58:24 am)

Re: Bank account balance is not the same in trial balance.

Not sure if it is the same issue, but what I am seeing is that journal entries that have been entered using the dropdown currency converter are not taken into consideration when obtaining the balance in the bank account inquiry.

Scenario:
1-My main currency is XAF, and I have a foreign bank account in EUR
2-I enter a JOURNAL ENTRY into this foreign account, in my local currency XAF, selecting the currency from the dropdown combobox (we may now do it in FA). Then I go to Bank Inquiry to look for that journal entry, and it does_not show up.
3-I repeat the same operation, but I do select EUR directly from the JOURNAL ENTRY, and I enter the journal in EUR. In this situation, I may see the journal entry when I check in BANK INQUIRY.

This makes GENERAL LEDGER balance not match with BANK INQUIRY balance.

Is this an expected behavior? Is FA expecting all bank movements to be entered directly as Bank deposits/withdraws?

GL INQUIRY view
BANK INQUIRY view

Re: Bank account balance is not the same in trial balance.

The bank entry can be in bank currency. General ledgers always in a home currency, it will be applied with exchange rate and maintain in company currency one.

If the bank account is not home currency. The GL balance doesn't same with bank balance.  Hope that explains.

8 (edited by albertolima 05/07/2021 01:27:23 am)

Re: Bank account balance is not the same in trial balance.

I still see a missed entry when I do BANK_INQUIRY
Journal Entry    110    086/2021    05/07/2021    10.00        -40.00        TEST-Journal entry in EUR

This is the same bank account from GENERAL LEDGER INQUIRY
Journal Entry    110    086/2021    05/07/2021             6,559.57        551,615.82    TEST-Journal entry in EUR
Journal Entry    111    087/2021    05/07/2021             6,560.00        558,175.82    TEST-Journal entry in XAF


Journal entry #111 is missing from Bank Account inquiry.
It was entered in XAF, and converted using the dropdown currency converter, but the data is not saved into the bank_trans database, therefore the gl account and the bank account balances do not match.

I believe the intention is to have them match both ways: if you enter it through banking, it must show on GL; if you enter the journal from GL, it should show on banking. Am I getting it wrong?

Re: Bank account balance is not the same in trial balance.

Looks like a strange issue.  I just tried to make one myself local version. Looks it create both entries ( gl_trans and bank trans) both tables.

1. Did you made any change in FA program..?

2. Check your error log and get us the error detail?.

3. If possible record a video from test company and show us ?

Re: Bank account balance is not the same in trial balance.

The bank account must be in foreign currency
Then create a journal entry onto that bank account related gl account, in local currency
Then, go to bank inquiry, and that journal entry is not there

I shall check with a different installation tonight and revert back with a video link if the issue is not a corrupted setup


++++++++++++++


kvvaradha wrote:

Looks like a strange issue.  I just tried to make one myself local version. Looks it create both entries ( gl_trans and bank trans) both tables.

1. Did you made any change in FA program..?

2. Check your error log and get us the error detail?.

3. If possible record a video from test company and show us ?