Skip to content

Payments with QuickBooks

With QuickBooks connected, payments are kept in one place and show in both. Which place is the Payments are recorded in the accounts package setting on Administration → Accounts Package. It’s switched on when QuickBooks is first connected, because most companies receive payments and reconcile their bank feed in QuickBooks.

Payments made in QuickBooks (the usual way)

Section titled “Payments made in QuickBooks (the usual way)”

With Payments are recorded in the accounts package on:

  • Receive payments in QuickBooks as you always do, for example with Receive payment or when you match your bank feed.
  • Each one shows on the invoice here within a few minutes, with the date, the amount applied to that invoice and QuickBooks’ reference number. Its method is From accounts. One payment against several invoices shows on each of them, for the part applied to it.
  • Invoices show Paid, Part paid or Overdue from those payments, and the invoice list’s Unpaid, Overdue and Paid views work.
  • The customer’s summary shows their Balance and anything Overdue from those payments, and they count towards the credit limit, including the warning when an order is confirmed.
  • On Home, the Owed to you chart and the Cash received, Debtors and Days to pay figures use them too.
  • They’re read-only here: there’s no Record payment…, and they can’t be voided here.
  • If a payment is deleted, voided or changed in QuickBooks, it’s voided here with the reason Changed in QuickBooks. A changed one is then shown again as it is now.

A credit note applied in QuickBooks doesn’t add a payment here, even though QuickBooks shows it as a payment of £0.00: the credit note itself already reduces what’s owed.

With Payments are recorded in the accounts package off:

  1. Record the payment on the invoice here with Record payment…, as usual.
  2. It goes to QuickBooks as a payment against the same invoice, into the account for its payment method.
  3. Voiding it here with Void payment voids it in QuickBooks too. QuickBooks keeps it, at £0.00, marked as voided.

A payment waits for its invoice to reach QuickBooks first. A payment on an invoice that never goes to QuickBooks (one dated before the start date) stays here only.

Under Payments on Administration → Accounts Package, pick where each payment method’s payments go. The list has your QuickBooks bank accounts and Undeposited Funds:

  • Any other method (the default): where payments go when their method has no account of its own. Choose this one first.
  • Each payment method: leave it on Use the default, or pick its own account. Choose Undeposited Funds for payments you bank together, such as cheques, so you can group them into one deposit in QuickBooks.

Until there’s a default, a payment whose method has no account is refused on the sync queue. Choose one, then retry it there.