Need instructions to check and resolve an error when posting cash/bank documents - insufficient funds
- Which reports can be used to check the balance on this date (Cash assets balances)
- generate the Statement of GL (for f/example, account 2050100 Cash on hand) and analyze the movement on this account
- check - compliance with the chronology of documents, cash register, entity
When posting Cash or Bank documents, the system may display an Insufficient Funds error indicating insufficient funds. This occurs happens when the account balance on the posting date is not enough to cover the transaction amount. In some casesSometimes, clients may believe have sufficient funds are availablebalance, but the system still shows an error.
Use the following checklist to identify and resolve the issue:
1.
...
Verify Cash
...
Balance
...
Open the Cash Assets Balances Report.
Money module > Reports > Cash Assets Balances
Select the relevant
...
Review the available balance to confirm if sufficient funds exist.
2. Generate General Ledger Statement
...
Run the Statement of GL for the relevant account (for example, 2050100 – Cash on Hand).
...
Analyze the movements (debits/credits) and running balance.
...
filters: choose the Entity, Cash/Bank Account, and Balance Date.
Note!!!
The system checks balances up to the selected date, not the document date.
This means payments can be created in advance, even if no balance exists on that document date.
For accurate reporting, always use the Current Date as the "On Date".
Enter documents on the actual date received/paid, and repost any pre-dated or post-dated documents to ensure correct balances.
2. Type of Cash Account
Check that the correct Cash Account is selected in the document. Sometimes accounts may have the same name but different codes (for example, two accounts named PETTY CASH). To avoid confusion, it is advisable to keep a slight difference in their descriptions. Always verify the Account Code when posting to ensure the correct account is used.
3. Check Document Chronology and Compliance
Ensure that all documents (receipts, payments, transfers) are recorded in the correct chronological order.
...
Verify that the cash register assigned to the document matches the entity’s configuration.
...
Confirm that there are no missing or incorrectly dated entries affecting the running balance.
4. Corrective Actions
...
If funds are genuinely insufficient:
Adjust the payment amount.
Record an incoming cash/bank transaction (deposit, transfer, etc.) before reposting.
If the issue is due to incorrect chronology or misposting:
...
Correct the posting date of the document(s).
...
Reassign the document to the correct cash register/entity.
...
Users can check the details of a document by double-clicking on the balance in the report. This will open a dialog box with a Select Field option. Choose Document and click Select.
A list of documents contributing to the balance will then be displayed. This will help identify any missing documents or incorrectly dated entries and ensure the running balance is accurate.
4. Review GL Movements
To review GL movements, generate the statement for the relevant GL account (e.g., 2050100 - Cash on Hand) and check the debits, credits, and running balances up to the posting date to identify why the error occurred
Thanks for being a Firstbit Customer! #InsufficientFundsError #CheckAccountBalance #ReviewGLMovements#VerifyDocumentChronology