QuickBooks Account Register

Which accounts have a register

Intuit lists the account types that have registers: Bank, Credit Card, Fixed Assets, Other Fixed Assets, Other Current Assets, Long-term Liabilities, Other Current Liabilities and Equity. Every one of them is a balance sheet account, an account that carries a balance forward from one day to the next.

Two balance sheet accounts come with a caveat. Intuit says "Some accounts, such as Accounts Receivable or Accounts Payable, have registers that cannot be edited directly." Those balances are built from invoices, payments and bills, so you change them by changing those forms, not by typing into the register.

Income and expense accounts are not on the list. Their balances describe a period, not a point in time, so to see what hit your sales or Stripe fees account, run a report on it instead, such as the General Ledger.

For Stripe money, the account types that matter are the ones your Stripe setup uses: the bank account payouts land in, and the asset account that stands in for the Stripe balance itself. Liabilities such as sales tax collected through Stripe or a gift card balance have registers too.

Opening and reading a register

Intuit’s path is Settings, then Chart of accounts, then find the account and select View register from the Action column.

Three controls do most of the work. The Find field searches "by amount, reference number, or memo", which is the fastest way to locate one payout or one sale. The filter icon narrows the list, for example to one transaction type, and "Clear filter / View All" resets it. And you can "sort and reorder the list of transactions by date, reference number, type of payment, or reconcile status."

Sorting has one trap. The running balance is calculated in date order, and Intuit notes that sorting by a column other than date or reconcile status makes the Balance column show n/a. If your register suddenly has no balances, click the Date header.

To change a transaction, select it to expand the row and edit the fields shown. Some fields are grayed out in the register view, and for those Intuit says to select Edit to open the full form. Settings at the top of the register lets you hide columns, and Paper Ledger Mode lays it out like a traditional checkbook.

Finding what broke a Stripe holding account balance

The most common reason to open a register in a Stripe business is a mismatch: the account that holds your Stripe money says one number and Stripe’s Balance summary report says another. The register lets you find the day it went wrong instead of re-checking the whole month.

Work backwards through the running balance. Pick a date where you know the two agreed, such as the last reconciled month end, and compare the register balance with Stripe’s ending balance day by day after that. The first day they differ is where the problem is, and the rows on that day are a short list to check.

The usual culprits look distinctive in a register. A duplicate shows as two rows with the same amount and date, often one synced and one entered by hand. A missing fee shows as a balance that is high by a few dollars that add up to Stripe’s fee on one payment. A payout recorded on the day the bank received it, rather than the day Stripe took it from the balance, shows as a balance that is high for a day or two around month end and then corrects itself. And a payout recorded twice, once from the bank feed and once as a transfer, shows as the same amount leaving the account twice.

Once the balance is fixed, reconcile the account to lock it in. Intuit lists reconciling transactions and reviewing reconciliation adjustments among the things you can do from a register.

How transactions get into a register

Intuit names three routes: sales forms such as invoices and expenses, which post to the account as a side effect; online banking, where downloaded transactions "are added to registers after your review"; and direct entry, typing a transaction straight into the register.

The first route is how nearly everything reaches a Stripe holding account. A sales receipt deposited to it, a fee expense paid from it and a transfer moving a payout out of it each show up as a row without anyone opening the register. That is also why a Stripe holding account’s register should rarely need direct entry. A row typed straight into it is a correction someone made by hand, and it is worth a memo saying why.