QuickBooks Online
Connect your QuickBooks Online company and every payment Pilaster records is booked there as a sales receipt: dues, event registrations and sponsorships, by check, cash or online. Refunds, corrections and deletions follow, so your books keep up without anyone typing payments in twice.
The short version
- An owner or admin connects QuickBooks in Chamber Settings, Accounting, and picks your company at Intuit.
- Choose an income account for each kind of money, where checks and cash are deposited, where online payments go, and the first day to send. Nothing is sent until you save those.
- Each payment becomes one sales receipt, for the member business (or sponsor) as a QuickBooks customer.
- Payments go over within a few minutes of being recorded. Sync Now sends them straight away.
- Editing a payment updates its receipt. Deleting one, or canceling a registration paid by cash or check, voids it. A refund is booked as a refund receipt.
- Payments from before the first day are never sent, so nothing you already entered by hand is booked twice.
- If you take payments online, each Stripe payout is booked as one deposit to your bank, for exactly what the bank received, with Stripe's fees as an expense.
- This connects QuickBooks Online. If your chamber uses QuickBooks Desktop, ask us and we will work out a setup with you.
Connecting QuickBooks
- Open Chamber Settings, Accounting.
- Click Connect QuickBooks. You're taken to Intuit to sign in and choose the company to connect.
- Back in Pilaster, the panel says Choose where payments go. Pick the accounts (below) and click Save. The first payments are sent as you save.
Only owners and admins can connect, change the accounts, sync or disconnect. Everyone else on the team can see the panel with those controls greyed out.
A chamber in evaluation mode can't connect QuickBooks: its payments are pretend, and they're kept out of your books. The Accounting tab shows what the connection does, with Connect QuickBooks greyed out until you go live. See Evaluation mode.
Choosing where payments go
Income
Each kind of money is booked to an item in QuickBooks, and each item to the income account you choose:
- Membership Dues. If you have no account for it yet, choose New account: Membership Dues and it's made for you.
- Event Registrations. If you have no account for it yet, choose New account: Event Income and it's made for you.
- Sponsorships. If you have no account for it yet, choose New account: Sponsorship Income and it's made for you.
If your company already has an item with one of those names, it's used, and pointed at the account you chose. Changing an account later applies to payments sent from then on. Receipts already sent stay as they are.
Deposits
- Checks and cash are deposited to the account you choose, usually Undeposited Funds, so you can group them into the bank deposit you actually made.
- Online payments go to a clearing account for Stripe (choose New account: Stripe to have one made). The money waits there until Stripe pays it out to your bank (see Stripe payouts, below).
The first day to send
Payments recorded in Pilaster on or after this day are sent. It starts as today. Set it earlier to send payments you haven't entered in QuickBooks yet. Moving it earlier later on asks first, since anything you entered by hand would then be there twice.
Stripe payouts
Once your chamber takes payments online, a third group appears, Stripe payouts:
- Paid out to: the bank account Stripe pays out to.
- Stripe fees: an expense account for Stripe's fees, and for disputes. Choose New account: Stripe Fees to have one made.
- Other Stripe money: an income account for anything Stripe paid out that didn't come through Pilaster, such as a charge someone made in the Stripe dashboard. Choose New account: Other Stripe Income to have one made.
What's sent
A sales receipt per payment
- Dues: for the member business, numbered P- and the receipt number, described with the dues level and the period it covered, with the check number if there is one.
- Event registrations: paid ones only, numbered E- and the ticket code, described with the event and who registered. A member's registration is booked to the member business; everyone else's to one customer, Event guests.
- Sponsorships: for the sponsor, numbered S-, described with the package and the event or year.
A customer is found by its name, or made. If a vendor already has the name, the customer gets "(member)" added, since QuickBooks needs names to be different. Dues, tickets and sponsorships are sent untaxed.
Changes after sending
- Editing a payment's amount, date, method or check number updates its receipt.
- Deleting a payment, or canceling a registration paid by cash or check, voids the receipt. It stays in QuickBooks at $0, marked Voided.
- A refund through Stripe is booked as a refund receipt, from the online payments account, for the amount refunded.
- If someone deletes a receipt in QuickBooks, it's sent again the next time that payment changes.
A deposit per Stripe payout
Stripe pays your balance out to your bank in batches, less its fees. Each payout is booked as one deposit to the bank account you chose, dated the day it reached the bank and for exactly that amount, so it matches your bank feed. Its lines are:
- the payments and refunds already sent from Pilaster, moved out of the online payments account;
- any other Stripe money, to the other Stripe money account;
- disputes and Stripe's fees, taken out to the fees account.
With every payout booked, the online payments account holds only what Stripe hasn't paid out yet. Payouts are checked about once an hour, and Sync Now checks straight away. Payouts that reached the bank before the first day to send aren't booked. Stripe can't list what a payout made by hand (rather than on Stripe's schedule) contained, so one of those is listed under Couldn't send for you to record yourself.
When something can't be sent
If QuickBooks turns a payment down (an account was deleted, or its date is in a closed period), the panel shows it under Couldn't send with QuickBooks' reason. It's tried again by itself, less often each time. Fix what QuickBooks says, then click Sync Now to try straight away.
If QuickBooks stops accepting the connection (someone disconnected it at Intuit, for instance), the panel says QuickBooks needs connecting again and nothing is sent until you click Reconnect. Connect the same company and it carries on where it stopped, without sending anything twice. The dashboard says so too, under Needs attention, with Open Accounting. If it was disconnected on purpose, an owner or admin can dismiss that, which disconnects it in Pilaster as well.
Disconnecting
Click Disconnect in Chamber Settings, Accounting. New payments stop being sent, and receipts already sent stay in QuickBooks. Connecting the same company again picks up where it left off. Connecting a different company starts over: you choose its accounts and first day again.