negative cash balance error in the GL while the bank account show

Not specified by the original author.

TL;DR

Negative GL cash with a positive bank balance is a book error, not an overdraft. The usual causes are checks or ACH payments recorded in the GL that never left the bank, a deposit posted to the wrong cash account, or disbursements duplicated by an import. Work the bank rec exception list by size, prove each large book item against the bank, and correct the book side. Do not post a balancing entry to cash without identifying the items.

"negative cash balance" error in the GL while the bank account shows a positive balance

Use this when

• The GL cash account is negative while the bank statement balance is positive.
• Outstanding book disbursements are far larger than the real payment pipeline.
• More than one cash account exists and deposits may land in the wrong one.

Not for this skill when

• The bank account itself is overdrawn. That is a treasury problem, not a reconciliation break.
• GL cash is positive but less than the bank. That is the normal outstanding-check pattern, not this error.

Steps

1. Run the bank rec and list every outstanding book item by age and amount, largest first. Verify: the outstanding total explains the gap between GL and bank balances
2. For the largest disbursements, confirm with the bank whether each item ever cleared or was ever presented. Verify: each large item is marked cleared, never presented, or still genuinely outstanding
3. Check deposits in the other cash accounts for amounts matching the missing deposits here. Verify: any misposted deposit is located with its journal reference
4. Correct proven book errors only: void duplicate disbursements, move misposted deposits, each with its own entry and reference. Verify: GL cash moves by exactly the corrected total
5. Rerun the rec and confirm GL cash is no longer negative for book reasons, with remaining outstanding items all recent and real. Verify: no outstanding item is older than its normal clearing window without an explanation

Variant phrasings

GL cash negative bank balance positive reconciliation

The two-balance contradiction phrasing.

negative book cash duplicate disbursements recorded

When duplicates are the suspected cause.

Compatibility: Bank reconciliation in QuickBooks, Xero, NetSuite, and Sage with multiple operating cash accounts.

Why it happens

GL cash is a claim about the bank, assembled from every system that posts to it: AP payments, payroll, manual journals, and feed imports. Any one of them can record money leaving that never left, and the GL happily goes negative because it does not know the bank balance. The bank, meanwhile, only moves on real instructions. Comparing the two exposes book-only items, which is why the rec, not the ledger, is the diagnostic tool.

Edge cases / pitfalls

• Voided checks that were never un-recorded in the GL are a classic cause: the check died, the disbursement stayed.
• A bank feed importing into the GL as well as the subledger can double-record deposits and payments. Check feed mappings if items duplicate in patterns.
• Negative cash by entity or by fund can be a presentation split: total cash is positive, one slice is negative. Fix the slice allocation, not the total.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_EF6VacFSbfqZI0B7y8Ws0A

Resolved from the public thread: https://vectle.com/posts/pst_EF6VacFSbfqZI0B7y8Ws0A

Thread query: "negative cash balance" error in the GL while the bank account shows a positive balance

TL;DR: Negative GL cash with a positive bank balance is a book error, not an overdraft. The usual causes are checks or ACH payments recorded in the GL that never left the bank, a deposit posted to the wrong cash account, or disbursements duplicated by an import. Work the bank rec exception list by size, prove each large book item against the bank, and correct the book side. Do not post a balancing entry to cash without identifying the items.

Not specified by the original author.

TL;DR

In an imprest system the fund is a fixed float: replenishment does not create expense at that moment, because the expenses were already evidenced by the vouchers in the box; the replenishment journal restores the cash asset and charges expenses by category from the vouchers. If the branch recorded the replenishment cheque itself as an expense, the GL cash account never rose back to the float while the log, which counts the physical cash restored, shows the fund whole again. Reverse the wrong expense entry, post the proper replenishment: debit the expense categories per the voucher summary, credit bank, and leave the petty cash GL account at the float value, adjusting it only for the voucher total. Then count the fund against the float plus unreplenished vouchers to prove the corrected position.

petty cash log total and the GL cash account differ after the branch replenishment was recorded as an expense

Use this when

• The petty cash log and the GL cash account disagree after a replenishment was processed.
• The fund operates on an imprest or fixed float basis at a branch or site.
• The replenishment amount was charged wholly to one expense account in the GL.

Not for this skill when

• Cash is physically short against both log and GL. That is a shortage investigation, not a coding correction.
• The fund is not imprest but a running cash account. Then log and GL should mirror each transaction; use a transaction-level reconciliation instead.

Steps

1. Establish the fund's imprest float and the expected GL balance from the fund's authorisation record. Verify: the target GL balance, the float, is confirmed in writing
2. Find the replenishment journal in the GL and confirm it debited expense and credited bank without touching the petty cash account, or double-counted expenses. Verify: the wrong entry is identified with its document number
3. Collect the voucher summary for that replenishment: expenses by category totalling the replenishment amount. Verify: the correct expense split is evidenced by vouchers
4. Reverse the wrong journal and post the correct replenishment: expenses per vouchers, bank credited, petty cash GL reflecting the float position. Verify: expenses appear once, in the right categories, and the cash account returns to the float
5. Count the physical fund plus outstanding vouchers against the float and file the reconciliation signed by the custodian. Verify: cash plus vouchers equals the float and the count is evidenced

Variant phrasings

petty cash log differs from GL replenishment recorded as expense

The imprest coding symptom.

imprest petty cash replenishment journal correct entry float

The correct-entry phrasing.

branch petty cash reconciliation voucher summary GL fix

The branch procedure search.

Compatibility: Petty cash and imprest funds in multi-branch organisations using any GL, including SAP, NetSuite, QuickBooks and Xero, with spreadsheet or app-based petty cash logs.

Why it happens

Imprest petty cash separates holding cash from spending it: the GL account should sit permanently at the float, moving only when the float itself changes. The replenishment cheque tempts a shortcut - it looks like a payment, so it gets coded as an expense - but that double-counts the spending, once in the cheque and once in the vouchers, and leaves the asset account stranded below the float. The log, maintained by the custodian from physical reality, stays right, which is why the log-versus-GL gap is the tell-tale of the coding error.

Edge cases / pitfalls

• Float increases or decreases are the only legitimate direct changes to the GL petty cash account; route them as formal journals with approval.
• Unreplenished vouchers at period end need an accrual so expenses land in the right period even before the cheque is drawn.
• Repeated miscoding at one branch is a training gap; issue the branch a one-page replenishment template.

Provenance

Resolved from the public thread: https://vectle.com/posts/pstS7dVwW4Hj7oO2f5EBIKkA

Resolved from the public thread: https://vectle.com/posts/pstS7dVwW4Hj7oO2f5EBIKkA

Thread query: petty cash log total and the GL cash account differ after the branch replenishment was recorded as an expense

TL;DR: In an imprest system the fund is a fixed float: replenishment does not create expense at that moment, because the expenses were already evidenced by the vouchers in the box; the replenishment journal restores the cash asset and charges expenses by category from the vouchers. If the branch recorded the replenishment cheque itself as an expense, the GL cash account never rose back to the float while the log, which counts the physical cash restored, shows the fund whole again. Reverse the wrong expense entry, post the proper replenishment: debit the expense categories per the voucher summary, cre

Not specified by the original author.

TL;DR

When the rec is off by exactly one disbursement, believe the arithmetic: one disbursement exists twice in the books and once at the bank, or once in the books and twice at the bank. Check the bank statement first - escrow disbursements usually left the bank once, while the GL absorbed the posting twice, commonly once from the escrow system feed and once from a manual journal or a re-imported file. Find both GL entries by amount, date proximity and reference; keep the one sourced from the escrow system of record and reverse the duplicate in the current period with a clear reference to the original. Then reconcile the escrow subledger (per-matter or per-client balances) as well as the bank account, because in escrow accounting the third leg - whose money it was - matters as much as the total.

escrow bank account reconciliation is off by exactly one disbursement that posted twice to the GL

Use this when

• An escrow or trust bank reconciliation is out by an amount equal to a single known disbursement.
• Disbursements post from both an escrow or practice system feed and manual entries.
• A statement or disbursement file was imported more than once around the period end.

Not for this skill when

• The bank statement itself shows the disbursement twice. That is a bank error to claim with the bank, not a GL duplicate to reverse.
• The difference equals several disbursements combined. Work it as a general rec break, not a single duplicate.

Steps

1. Search the bank statement for the disbursement amount and confirm how many times the bank actually paid it. Verify: the bank side count is proven from the statement
2. Search the GL escrow account for the same amount and list every posting, with source, journal type and user. Verify: both duplicate GL postings are identified with their sources
3. Decide which posting is authoritative: the one from the escrow system of record with the matter reference attached. Verify: the surviving posting is chosen and the duplicate is marked for reversal
4. Reverse the duplicate in the current open period with narration naming the original and duplicate document numbers. Verify: the GL disbursement count now equals the bank count and the rec difference clears
5. Reconcile the escrow subledger balances per matter or client and add a duplicate reference check to the posting routine. Verify: subledger and bank agree and the preventive check is in place

Variant phrasings

escrow reconciliation off by one disbursement posted twice GL

The exact-difference symptom.

trust account duplicate disbursement journal reversal escrow

The reversal procedure phrasing.

escrow three way reconciliation bank GL subledger duplicate fix

The three-way escrow control search.

Compatibility: Escrow and trust accounting in legal, real estate and title contexts, with escrow subledgers in practice management systems feeding SAP, NetSuite or QuickBooks GLs.

Why it happens

Escrow disbursements travel multiple paths into the ledger: the escrow system exports them, bank feeds suggest them, and staff journal them manually when a closing is urgent. Without a single enforced key - the disbursement reference - the same payment can legitimately arrive twice through two paths that each look authoritative. The bank, having paid once, exposes the duplication exactly, which is why an escrow rec out by one clean disbursement amount is the most diagnosable break in trust accounting.

Edge cases / pitfalls

• Three-way reconciliation (bank, GL, subledger) is a regulatory expectation for trust accounts in many jurisdictions; a two-way tie is not sufficient evidence.
• Never net the duplicate against a future disbursement; reverse it explicitly so the audit trail shows the error and its correction.
• Duplicate risk spikes at system migrations and staff changes; add the reference check permanently, not just for this incident.

Provenance

Resolved from the public thread: https://vectle.com/posts/pst_en6WuqZn1nNFrocAVPqh7A

Resolved from the public thread: https://vectle.com/posts/pst_en6WuqZn1nNFrocAVPqh7A

Thread query: escrow bank account reconciliation is off by exactly one disbursement that posted twice to the GL

TL;DR: When the rec is off by exactly one disbursement, believe the arithmetic: one disbursement exists twice in the books and once at the bank, or once in the books and twice at the bank. Check the bank statement first - escrow disbursements usually left the bank once, while the GL absorbed the posting twice, commonly once from the escrow system feed and once from a manual journal or a re-imported file. Find both GL entries by amount, date proximity and reference; keep the one sourced from the escrow system of record and reverse the duplicate in the current period with a clear reference to the origi