Do not force a journal entry before confirming which report the customer is comparing (Aged Payables vs. Payables Reconciliation), checking for GJ/CD entries posted directly to AP, or checking whether a vendor prepayment or a recent Start a New Year is the real cause.
AP/vendor-bill calls are most often Bookkeeper Brenda (managing vendor files, reconciliations, and electronic payment setup for a client) rather than a DIY owner.
AP out-of-balance discovery, vendor-prepayment and fiscal-year timing issues, refunding or reversing a bill without breaking inventory value, and setting up electronic (ACH) vendor payments. Built from AccountEdge’s internal knowledge base — not yet from real CRM cases (see the Common Patterns section).
AP out-of-balance calls, vendor-prepayment and fiscal-year timing issues, reversing a purchase order without breaking inventory value, refunding a bill, and setting up electronic vendor payments.
This guide is an internal playbook for Accounts Payable and Vendor Bill troubleshooting calls — AP out-of-balance reports, vendor-prepayment and fiscal-year timing issues, reversing a purchase order without breaking inventory value, refunding a bill, and setting up electronic vendor payments.
| Core principle | AccountEdge is a double-entry system — every transaction hits two accounts. Almost every “my AP doesn’t match” call is a misallocated account or a report-methodology mismatch, not a missing bill or a software bug. |
|---|
| What this guide covers | Why it matters |
|---|---|
| AP out-of-balance discovery | Customers often compare Aged Payables against the Balance Sheet instead of the Payables Reconciliation report, which looks like a bug but isn’t one. |
| Vendor prepayment & fiscal-year timing | A bill dated after its payment, or a purchase order that straddles a Start a New Year boundary, can show as a false out-of-balance amount. |
| Reversing/refunding a bill | Reversing or deleting a purchase order can push an item’s inventory value below $0 if the steps aren’t done in the right order. |
| Electronic (ACH) vendor payments | Setup requires two distinct bank-type accounts and Forte merchant credentials — a missed or reused account is the most common failure. |
A note on sourcing: this guide is built from AccountEdge’s internal AR/AP/Bank-Rec knowledge base synthesis document and the internal Payments/Banking KB — not from live CRM case data. Like the Sales/Invoicing/AR guide, 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 AP/vendor cases can be added.
AP support is different from a typical how-to call because the customer is usually looking at a dollar difference between two reports, or a warning message blocking an action — not a specific broken feature. The rep’s job is to prove which two things are being compared, or which sequencing step was skipped, 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 Payables Reconciliation report — not the Aged Payables report, which isn’t designed to match it. |
| An out-of-balance AP account is almost always a misallocated transaction, not a missing one. | Use Find Transactions on the AP account and review the SRC column for General Journal (GJ) or Cash Disbursement (CD) entries that shouldn’t be there. |
| A bill or purchase order that looks off may be a timing issue, not a data-loss issue. | Check whether a payment is dated before its bill (vendor prepayment), and whether a recent Start a New Year is involved. |
Do not suggest a blanket journal entry before running Find Transactions to isolate the specific entry causing the mismatch.
Do not reverse or delete a purchase order without first checking the item’s current inventory value — doing so out of sequence can value inventory below $0.
Do not set up electronic vendor payments without first confirming two distinct bank accounts exist — reusing Undeposited Funds or the Accounts Payable account itself will not work.
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 bill or payment causing the difference before we talk about a journal entry.”
All AP and vendor-bill 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 (AP), which report they’re comparing, and the exact dollar difference (or the exact warning message text). | Rep can restate the issue in one sentence. |
| 2. Question | Narrow the likely cause. | Ask whether any GJ/CD entries touch AP directly, whether a payment predates its bill, and whether Start a New Year was recently run. | Rep has a short list of likely causes. |
| 3. Test | Prove the break point. | Use Find Transactions with the A/P account selected, plus the Account Transactions and Trial Balance Detail reports customized to that account, to isolate non-PJ entries; for inventory-value warnings, check the item’s current Total Value first. | Rep can point to the exact transaction(s) or the exact value gap causing the issue. |
| 4. Implement | Apply the confirmed fix. | Correct or re-record the specific transaction, adjust inventory value before reversing a PO, or explain that historical Purchases/Debit Memos legitimately touch 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 Payables Reconciliation report, not Aged 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 Purchases Journal. | Non-item transactions referencing the Inventory Asset or AP account directly. |
| Entry source (SRC column) | Whether GJ or CD entries appear against AP in Find Transactions. | PJ (purchases) and CD (payments) should be the normal entries for AP; GJ generally shouldn’t. |
| Bill vs. payment dates | Whether any payment is dated before its related bill. | Vendor-prepayment timing shows as a false out-of-balance amount. |
| Fiscal-year boundary | Whether a Start a New Year was recently processed around the transaction dates in question. | A purchase order can appear to be missing right after year-end rollover even though it’s a reporting-date artifact. |
| Inventory value before reversing a PO | The item’s current Total Value on the Items List [Summary] report, before reversing or deleting any purchase. | Average cost has dropped since the purchase was recorded, which can value inventory below $0 if reversed out of sequence. |
| Customer symptom | Likely causes | First checks |
|---|---|---|
| “My AP doesn’t match my Balance Sheet” | Comparing against Aged Payables instead of Payables Reconciliation, or a GJ/CD entry hit AP directly. | Re-run Payables Reconciliation for the same date; use Find Transactions on the AP account and review the SRC column. |
| “AP is out of balance for a bill I know is right” | Vendor prepayment — the bill is dated after its payment. | Run Payables Reconciliation Exceptions for a date far in the future; if the out-of-balance disappears, it’s a timing issue. |
| “AP looks off right after Start a New Year” | A purchase order or bill straddles the fiscal-year boundary. | Re-run Payables Reconciliation for a later date to confirm it’s a reporting-date artifact, not missing data. |
| “This Will Value Your Inventory at Less Than 0” warning | The item’s average cost has dropped since the purchase was recorded, and the customer is trying to reverse/delete that purchase order. | Check the item’s current Total Value on Items List [Summary] before reversing or deleting anything; follow the inventory-value-floor procedure. |
| “Electronic vendor payment / Direct Deposit won’t set up” | Missing or reused bank accounts, or missing Forte merchant credentials. | Confirm two distinct Asset/Bank accounts exist, separate from Undeposited Funds and Accounts Payable, and that credentials are entered in Business Services Setup. |
| “A Spend Money transaction won’t balance” | Missing allocation account on the transaction. | Add the allocation account and save the transaction. |
Open Find (bottom left corner), click the Account tab, and select the Accounts Payable account.
Set the date range to 1/1/1990 through 12/31/9999 to see all transactions.
Review the SRC column. Purchases (PJ) and payments (CD) should be present; General Journal (GJ) 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: Payables Reconciliation Exception Report (Reports > Index to Reports > Accounts > Exceptions), Account Transactions Report (customized to only view the A/P Account, same date range), and Trial Balance Detail (customized to only view the A/P Account). Historical Purchases and Debit Memos legitimately debit/credit AP — don’t remove them.
If a bill is dated after the payment that’s been applied to it, this causes an out-of-balance issue.
Example: a bill created for a vendor on 7/20/2016 for $5,000, with a payment against it dated 7/15/2016. Running the Payables Reconciliation report for 7/15/2016 will show that $5,000 as an out-of-balance amount, because the payment was recorded before the bill.
Test: run the Payables Reconciliation report (Exceptions Report) for a date far in the future. If the out-of-balance amount disappears, it was caused by a vendor prepayment.
Fix: correct the payment date to on/after the bill date.
Example: a purchase order dated in FY 2009 (11/30/23), with payment not made until FY 2010 (1/20/24), and Start a New Year was processed on 3/15/24.
The purchase order referring to that vendor payment is no longer on file for the earlier period — but running the Payables Reconciliation report for a later date (e.g., 3/30/24) will show it back in balance.
This is a reporting-date artifact of the year-end rollover, not data loss. Re-run the reconciliation for a later date before assuming anything is broken or missing.
Warning message: “This sale item will leave you with positive on hand quantity and a negative value in inventory” (shown as “This Will Value Your Inventory at Less Than 0”). This appears when the average cost of an item on a purchase order has dropped since the purchase was recorded, and reversing/deleting that purchase order would take the item’s total inventory value below $0.
Before doing anything, create a backup of the company file.
Use the Index to Reports window to display the Items List [Summary] report. In the Total Value column, find the item’s current total inventory value.
Display the purchase order to be reversed in the Purchases window: open the Purchases Register window, click Journal, enter a date range that includes the transaction, locate it in the scrolling list, and click its zoom arrow.
Determine the original purchase amount for that line item (the Total field for that line).
Calculate the difference between the item’s original purchase amount and its current total inventory value (from the Items List [Summary] report).
Use the Adjust Inventory window to enter an adjustment for the item that increases its total inventory value by the calculated difference: enter 0 in the Quantity field, enter the difference as a positive number in the Amount field, and use a Cost of Sales account in the Account field. Click Record.
Display the purchase transaction again the same way. If the “Transactions CAN’T Be Changed; They Must Be Reversed” preference (Setup > Preferences > Security) is on, choose Reverse Purchase from the Edit menu and click Record Reversal. If that preference is off, choose Delete Purchase from the Edit menu instead.
Display a new Items List [Summary] report and confirm the item’s quantity and total inventory value are correct. If not, record another inventory adjustment to correct them. Consider entering a new purchase transaction with correct information to replace the one that was reversed or deleted, especially for multi-line purchase orders.
Turn on the reverse-only preference: Setup > Preferences > Security > enable “Transactions can’t be changed; they must be reversed.”
Open the bill, then open the bill’s payment (the payment window that looks like a blue check).
With the payment open: Edit > Reverse Payment. Confirm the date and record. This creates the refund in AccountEdge.
Open the bill again: Edit > Reverse. Confirm the date and record. This reverses the inventory receipt.
Go to Purchases Register > Returns & Debits tab.
Click the reversed bill to highlight it (do not open it), then click Receive Refund (bottom-left).
Turn the reverse-only preference back off.
Requires two Asset-type Bank accounts, different from each other and from both the Undeposited Funds and Accounts Payable accounts: a regular checking (operating) account, and a separate account typically named “Electronic Payments.”
Enter Forte Payment Systems merchant credentials in the Business Services Setup window: Setup > Electronic Payments > Set Up Electronic Payments & Deposits.
In that window, set the regular checking account as the Pay From Account — funds will ultimately be paid from this account.
Under Setup > Linked Accounts > Accounts & Banking Accounts, set the Linked Account for Electronic Payments to the separate Electronic Payments account.
When a vendor bill or employee is paid electronically, the payment posts against the Electronic Payments account first. When the payment is actually processed in the Prepare Electronic Payment window, funds are transferred from the checking (operating) account to satisfy it.
Symptom: a Spend Money transaction is unbalanced.
Root cause: missing allocation account.
Fix: add the allocation account and save the transaction.
Important: like the Sales/Invoicing/AR guide, the patterns below are not sourced from cited CRM cases — there is no confirmed real-case library for AP/Vendor Bills on the hub yet. These are documented patterns from AccountEdge’s internal 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 |
|---|---|---|
| AP used as allocation account outside a purchase transaction | AP balance drifts vs. its reconciliation report. | Use Find Transactions to isolate non-PJ entries in the SRC column; correct or reallocate them (check with the customer’s accountant before touching GJ entries they created). |
| Vendor bill dated after its payment | AP shows out of balance only as of a specific date. | Correct the payment date to on/after the bill date; confirmed by running Payables Reconciliation Exceptions for a future date. |
| Purchase order/bill straddling a Start a New Year boundary | AP looks out of balance, or a purchase order appears to be missing, right after year-end rollover. | Re-run Payables Reconciliation for a later date to confirm it’s a reporting artifact, not missing data. |
| Reversing/deleting a PO with a dropped average cost | “This Will Value Your Inventory at Less Than 0” warning blocks the reversal/deletion. | Adjust the item’s inventory value first (Module D procedure) before reversing or deleting the purchase. |
A good escalation lets a senior reproduce the issue quickly.
| Hand-off field | Required detail |
|---|---|
| Customer / case | Customer name, case ID, product/build, the AP account, and the exact dollar difference (or the exact warning message text). |
| Issue statement | One sentence describing the exact mismatch or blocked action. |
| Expected vs actual | What the Payables Reconciliation report should show vs. what the Balance Sheet is actually showing, or what the customer expected to happen vs. the warning they received. |
| What was checked | Which report was being compared, SRC-column review results, bill/payment date check, fiscal-year timing check, and (for inventory-value warnings) the item’s current Total Value. |
| Requested help | Confirm a misallocated transaction, approve a correcting journal entry or inventory adjustment, or request electronic-payment setup/credential investigation. |
Escalate when the rep cannot safely explain the mismatch after isolating non-PJ entries and checking prepayment/fiscal-year timing, or when electronic vendor payment setup still fails after confirming both accounts and credentials are correct.
Opening an AP-out-of-balance call
“Let’s make sure we’re comparing your Balance Sheet against the Payables Reconciliation report first, since that’s the one built to match it — then we’ll trace exactly which bill or payment is causing the difference.”
When the customer wants to reverse or delete an old purchase order
“Before we reverse or delete that purchase order, let’s check the item’s current inventory value — if the cost has changed since it was purchased, we may need to adjust the value first so we don’t end up with a negative inventory balance.”
When setting up electronic vendor payments
“Electronic vendor payments need two separate bank accounts in AccountEdge — your regular checking account and a dedicated Electronic Payments account — plus your Forte merchant credentials. Let’s confirm both accounts exist before we go further.”
This guide was built from AccountEdge’s internal AR/AP/Bank-Rec knowledge base synthesis document (an internal Word document with no public URL) and the internal Payments/Banking KB. No CRM case data has been incorporated yet — see the note in the Common Patterns section above.
Internal KB: AR/AP/Bank-Rec knowledge base synthesis document (Accounts Payable Out of Balance, Vendor Prepayment, Recently Started a New Fiscal Year, Refund a Bill and Remove Inventory, Inventory Value Less Than $0 sections) — internal document, no public URL.
Direct Deposit / Vendor Payment Setup: https://accountedge.helpjuice.com/direct-deposit---vendor-payment-setup
AccountEdge Knowledge Base: https://accountedge.helpjuice.com