When not to use this guide
Do not use this guide to force a journal entry before confirming which report the customer is comparing (Aged vs. Reconciliation) and checking for GJ/CD entries posted directly to AR/AP.
Do not use this guide to force a journal entry before confirming which report the customer is comparing (Aged vs. Reconciliation) and checking for GJ/CD entries posted directly to AR/AP.
AR/invoicing calls span both Bookkeeper Brenda (managing client files and reconciliations) and Solo Sam (DIY owners who need plain-language explanations, not accounting jargon).
AR/AP out-of-balance discovery, negative AR balances, payment-timing issues, and Web Pay / Direct Pay / credit-card payment troubleshooting. Built from AccountEdgeβs internal and public knowledge base — not yet from real CRM cases (see the Common Patterns section).
AR/AP out-of-balance calls, negative AR balances, payment-timing issues, and Web Pay / Direct Pay / credit-card payment troubleshooting.
This guide is an internal playbook for Sales, Invoicing, and Accounts Receivable troubleshooting calls — AR/AP out-of-balance reports, negative AR balances, payment-timing issues, and Web Pay / Direct Pay / credit-card payment questions.
| Core principle | AccountEdge is a double-entry system — every transaction hits two accounts. Almost every “my AR/AP doesn’t match” call is a misallocated account or a report-methodology mismatch, not a missing number or a software bug. |
|---|
| What this guide covers | Why it matters |
|---|---|
| AR and AP out-of-balance discovery | Customers often compare the wrong two reports against each other, which looks like a bug but isn’t one. |
| Negative AR balances | Usually caused by AR being used as the allocation account on a service or professional invoice instead of an income account. |
| Payment-timing mismatches | A payment dated before its invoice will show as out-of-balance as of the payment date even though nothing is actually wrong. |
| Web Pay, Direct Pay & credit-card payment questions | Connect-originated and Desktop-originated invoices/payments follow different edit, void, and visibility rules. |
A note on sourcing: this guide is built from AccountEdge’s internal AR/AP/Bank-Rec knowledge base and the public AccountEdge Knowledge Base (helpjuice.com) — not from live CRM case data. Unlike the Bank Reconciliation and Inventory guides, this guide does not yet have a real, case-number-cited “Real-World Case Library.” The Common Patterns section below is clearly labeled as KB-sourced, not case-sourced, until real Sales/Invoicing/AR cases can be added.
AR/AP support is different from a typical how-to call because the customer is usually looking at a dollar difference between two reports, not a specific broken feature. The rep’s job is to prove which two things are actually being compared before assuming anything is wrong.
| Assumption | What the rep should do |
|---|---|
| The customer may be comparing the wrong two reports. | Confirm they’re comparing the Balance Sheet against the Receivables/Payables Reconciliation report — not the Aged Receivables/Payables report, which isn’t designed to match it. |
| An out-of-balance AR/AP account is almost always a misallocated transaction, not a missing one. | Use Find Transactions on the AR/AP account and review the SRC column for General Journal (GJ) or Cash Disbursement (CD) entries that shouldn’t be there. |
| A negative AR balance or a payment that looks unapplied may be a timing or allocation issue, not a data-loss issue. | Check whether AR was used as the allocation account on a service/professional invoice, and whether any payment is dated before its invoice. |
Do not suggest a blanket journal entry before running Find Transactions to isolate the specific entry causing the mismatch.
Do not delete an approved credit card payment without walking through the proper steps — AccountEdge blocks this by design, and deleting the payment record does not reverse the actual charge through Forte.
Do not treat every Web Pay / Direct Pay question as a Desktop question — invoices and payments created in AccountEdge Connect follow different edit and visibility rules than Desktop-created ones.
Do not modify a General Journal entry the customer’s accountant created without checking with them first.
Rep coaching point
“Let’s first confirm which two reports you’re comparing, then we’ll trace the specific transaction causing the difference before we talk about a journal entry.”
All AR/AP and invoicing cases should move in this order: Discovery, Question Phase, Troubleshooting/Testing, and Implement Solution.
| Phase | Goal | Rep actions | Exit criteria |
|---|---|---|---|
| 1. Discovery | Understand exactly what the customer sees. | Get the exact account (AR or AP), which report they’re comparing, and the exact dollar difference. | Rep can restate the issue in one sentence. |
| 2. Question | Narrow the likely cause. | Ask whether this involves item or service transactions, whether any GJ/CD entries touch AR/AP directly, and whether any payment predates its invoice. | Rep has a short list of likely causes. |
| 3. Test | Prove the break point. | Use Find Transactions filtered to the AR/AP account, plus the Account Transactions and Trial Balance Detail reports, to isolate non-SJ/PJ entries. | Rep can point to the exact transaction(s) causing the difference. |
| 4. Implement | Apply the confirmed fix. | Correct or re-record the specific transaction, or explain that historical Sales/Credit Memos and Purchases/Debit Memos legitimately touch AR/AP and shouldn’t be removed. | Customer sees the corrected result or a clear next step. |
Use this checklist before changing anything in a live file.
| Checklist area | Rep should verify | Red flag |
|---|---|---|
| Report being compared | Customer is using the Receivables/Payables Reconciliation report, not Aged Receivables/Payables. | Customer is comparing two reports that were never designed to match. |
| Transaction type | Whether the entries in question are Item or Service/Misc transactions on the Sales/Purchases Journal. | Non-item transactions referencing the Inventory Asset or AR/AP account directly. |
| Entry source (SRC column) | Whether GJ or CD entries appear against AR/AP in Find Transactions. | SJ (sales) and CR (payments) should be the normal entries; GJ/CD generally shouldn’t touch AR/AP. |
| Payment vs. invoice dates | Whether any payment is dated before its related invoice. | Prepayment-before-invoice timing shows as a false out-of-balance amount. |
| Payment origin | Whether the sale/payment originated in AccountEdge Desktop or AccountEdge Connect. | Connect-originated invoices/payments have different edit, void, and visibility rules than Desktop-created ones. |
| Customer symptom | Likely causes | First checks |
|---|---|---|
| “My AR doesn’t match my Balance Sheet” | Comparing against Aged Receivables instead of Receivables Reconciliation, or a GJ/CD entry hit AR directly. | Re-run Receivables Reconciliation for the same date; use Find Transactions on the AR account and review the SRC column. |
| “My AR is a large negative number” | AR was used as the allocation account on a service or professional invoice instead of an income account. | Check the linked income account on the Item Information tab (item sales) or the invoice’s account field (service sales). |
| “A payment isn’t applying right / my balance looks off right after I entered a payment” | Payment dated before its invoice date. | Run Receivables Reconciliation Exceptions for a date far in the future — if the out-of-balance disappears, it’s a date issue. |
| “I can’t delete a credit card payment” | AccountEdge blocks deleting approved credit card payments by design (security). | Confirm whether they need it voided/refunded vs. genuinely removed; if removal is required, walk through temporarily disabling credit card processing. |
| “My customer says they can’t see their full invoice online” | The invoice was created in AccountEdge Desktop, not AccountEdge Connect. | Desktop-created invoices show only a summary in Web Pay’s My Account view; only Connect-created invoices show the full invoice. |
Open Find (bottom left corner), click the Account tab, and select the Accounts Receivable account.
Set the date range to 1/1/1990 through 12/31/9999 to see all transactions.
Review the SRC column. Sales (SJ) and payments (CR) should be present; General Journal (GJ) and Cash Disbursement (CD) entries generally should not appear.
Click the arrow next to any suspicious transaction to view it in full, then use Edit > Delete or Edit > Reverse to remove it, or change its allocation account.
Speak with the customer’s accountant before modifying any General Journal entry they created.
Helpful reports: Receivables Reconciliation Exception Report (Reports > Index to Reports > Accounts > Exceptions), Receivables Reconciliation, Account Transactions Report (filtered to AR, same date range), and Trial Balance Detail (filtered to AR). Historical Sales and Credit Memos legitimately debit/credit AR — don’t remove them.
Same approach as Module A, applied to the Accounts Payable account.
Helpful reports: Payables Reconciliation Exception Report (Reports > Index to Reports > Accounts > Exceptions), Account Transactions Report filtered to AP, and Trial Balance Detail filtered to AP.
Historical Purchases and Debit Memos legitimately debit/credit AP — don’t remove them.
This happens when the Accounts Receivable account was used as the allocation account on a service or professional invoice instead of an income (4-nnnn) account. For item invoices, check the linked income account on the Item Information tab instead.
Every erroneous sale debits and credits AR when recorded, so AR is understated and no income is being booked. When the customer later pays that invoice, the payment reduces AR even further (debit to cash/undeposited funds, credit to AR).
If this happened only a couple of times: reverse the invoices and payments, then re-enter them correctly.
If this has been happening for a long time and AR is a large negative number: correct it with a journal entry that debits AR to bring it to the right balance and credits the correct sales income account(s) — split across departments/jobs if needed. Use the Account Transaction Report for AR to find transactions where the same ID# appears as both a debit and a credit; that ID# pairing identifies the erroneous entries and their dollar amounts.
If the invoice is closed, use that dollar value in the correcting journal entry. If it’s still open, correct the transaction directly and re-allocate it to the right income account (and fix the Item Information screen first, for item invoices).
If a payment is dated before its invoice, it will show as an out-of-balance amount when reconciling as of the payment date.
Test: run the Receivables Reconciliation Exceptions report for a date far in the future. If the out-of-balance disappears, a prepayment-date issue is the cause.
Fix: correct the payment date to match or follow the invoice date.
Deleting an approved credit card payment (not normally possible or recommended): go to Setup > Credit Card Processing > Setup Credit Card Processing, uncheck “Credit Card Processing of Customer Payments,” delete the payment, then re-check the box to re-enable processing. This does not reverse the actual charge through Forte — it only removes the record from AccountEdge.
Voiding a Connect payment: a payment processed through Web Pay or by a Connect user via Customer Payment can be voided. Once it has synced to AccountEdge, the void must be done from the Desktop app. A credit/refund can only be processed in Desktop, and only after the payment has synced from Connect.
Web Pay invoice visibility: only invoices created in AccountEdge Connect show in full detail in the customer’s My Account page. Invoices created in AccountEdge Desktop show only a summary (sale date, due date, amount open, original amount, terms).
Direct Pay is different from Web Pay: it emails the customer a single invoice they can pay without creating or logging into a My Account. Web Pay, by contrast, gives the customer a full account showing every open receivable.
eCheck/ACH payments are supported through Web Pay (added in AccountEdge r34.x) at $1.99 per transaction (plus 1% on transactions over $5,000). ACH settlement is not instant — a failed settlement is retried automatically twice before the rep should reach out to the customer.
Important: unlike the Bank Reconciliation and Inventory guides, the patterns below are not sourced from cited CRM cases — there is no confirmed real-case library for Sales/Invoicing/AR on the hub yet. These are documented patterns from AccountEdge’s internal and public knowledge base only. Treat this as general guidance, not verified case history, until real case citations can be added.
| Documented pattern | What was seen | How it was resolved |
|---|---|---|
| AR used as allocation account (service invoice) | AR balance drifts deeply negative over time. | Change the invoice’s account to the correct income (4-nnnn) account; for a long-standing pattern, correct with a journal entry using the Account Transaction Report ID# column to match debit/credit pairs. |
| Payment dated before its invoice | AR looks out of balance only as of the payment date. | Correct the payment date to on/after the invoice date; confirmed by running Receivables Reconciliation Exceptions for a future date. |
| GJ or CD entries posted directly to AR/AP | AR/AP balance doesn’t match its reconciliation report. | Use Find Transactions to isolate non-SJ/PJ entries in the SRC column; correct or reallocate them (check with the customer’s accountant before touching GJ entries they created). |
| Approved credit card payment needs to be removed | Rep or customer wants a payment record gone after approval. | AccountEdge blocks this by design; temporarily disable Credit Card Processing to allow deletion, understanding this doesn’t reverse the actual charge through Forte. |
A good escalation lets a senior reproduce the issue quickly.
| Hand-off field | Required detail |
|---|---|
| Customer / case | Customer name, case ID, product/build, AR or AP account, and the exact dollar difference. |
| Issue statement | One sentence describing the exact mismatch. |
| Expected vs actual | What the Reconciliation report should show vs. what the Balance Sheet is actually showing. |
| What was checked | Which report was being compared, SRC-column review results, item vs. service transaction check, and payment/invoice date check. |
| Requested help | Confirm a misallocated transaction, approve a correcting journal entry, or request Connect/Web Pay sync investigation. |
Escalate when the rep cannot safely explain the mismatch after isolating non-SJ/PJ entries and checking date/allocation issues, or when a Web Pay/Connect sync or payment discrepancy needs backend investigation.
Opening an AR/AP-out-of-balance call
“Let’s make sure we’re comparing your Balance Sheet against the Receivables [or Payables] Reconciliation report first, since that’s the one built to match it — then we’ll trace exactly which transaction is causing the difference.”
When the customer wants a quick journal entry
“A journal entry can force the balance to match, but I want to find the specific transaction causing this first so we’re not covering up a misallocated invoice or payment.”
When a credit card payment needs to come off the books
“AccountEdge won’t let us delete an approved card payment directly — that’s intentional, since removing the record here doesn’t reverse the actual charge. Let’s confirm whether you need it voided, refunded, or genuinely removed from the file.”
This guide was built from AccountEdge’s internal AR/AP/Bank-Rec knowledge base synthesis document and the public AccountEdge Knowledge Base. No CRM case data has been incorporated yet — see the note in the Common Patterns section above.
AccountEdge Web Pay FAQs: https://accountedge.helpjuice.com/accountedge-web-pay-faqs
Deleting an Approved Credit Card Payment: https://accountedge.helpjuice.com/deleting-an-approved-credit-card-payment
Direct Deposit / Vendor Payment Setup: https://accountedge.helpjuice.com/direct-deposit---vendor-payment-setup
FAQs – Accepting eCheck/ACH Payments: https://accountedge.helpjuice.com/faqs---accepting-echeck-ach-payments
AccountEdge Knowledge Base: https://accountedge.helpjuice.com