Skill Tracer
Skills › Knowledge Work Plugins › payroll-prep › books_sync.md

books_sync.md

72 lines · small-business/skills/payroll-prep/reference/books_sync.md at 2574e29

Open on GitHub
1# Books Sync
2
3Posting the payroll to the ledger after it runs — through the connector when it has a
4journal-write path, otherwise as a balanced entry handed to the owner or bookkeeper to
5key in. Which ledgers can take the post through their connector is a capability that
6changes by release; check before promising it, and never name one ledger as the
7expected home for the entry.
8
9---

Books Sync

Posting the payroll to the ledger after it runs — through the connector when it has a journal-write path, otherwise as a balanced entry handed to the owner or bookkeeper to key in. Which ledgers can take the post through their connector is a capability that changes by release; check before promising it, and never name one ledger as the expected home for the entry.


Raw lines 1 to 10
11## Timing
13**Sync after the run is submitted, never before.** The proposed run and the run that actually happened differ any time the owner edited a line at the last step, and posting the proposal creates a journal entry that will not reconcile to the bank.
15Pull the final figures from the payroll provider where possible. Where the owner ran payroll manually, ask them to confirm the final gross and tax amounts before posting.
17---

Timing

Sync after the run is submitted, never before. The proposed run and the run that actually happened differ any time the owner edited a line at the last step, and posting the proposal creates a journal entry that will not reconcile to the bank.

Pull the final figures from the payroll provider where possible. Where the owner ran payroll manually, ask them to confirm the final gross and tax amounts before posting.


Raw lines 11 to 18
19## The entry
21A standard payroll journal has these components:
23| Account | Side | Source |
24|---|---|---|
25| Wages expense (or job cost) | Debit | Gross wages by person, allocated |
26| Employer payroll tax expense | Debit | Employer share only |
27| Payroll liabilities — taxes withheld | Credit | Employee withholding |
28| Payroll liabilities — employer taxes | Credit | Employer share |
29| Cash | Credit | Net pay actually disbursed |
31The entry must balance. If it does not, something in the source figures is wrong — say so and stop rather than plugging the difference to a suspense account. A forced balance hides the error permanently.
33---

The entry

A standard payroll journal has these components:

AccountSideSource
Wages expense (or job cost)DebitGross wages by person, allocated
Employer payroll tax expenseDebitEmployer share only
Payroll liabilities — taxes withheldCreditEmployee withholding
Payroll liabilities — employer taxesCreditEmployer share
CashCreditNet pay actually disbursed

The entry must balance. If it does not, something in the source figures is wrong — say so and stop rather than plugging the difference to a suspense account. A forced balance hides the error permanently.


Raw lines 19 to 34
35## Job costing
37When the business tracks labor to jobs, allocate wages expense by the job hours already captured on the timesheets.
39- Allocate at **fully burdened cost** when the owner has given a burden rate. Otherwise allocate raw wages and label it as such.
40- **Do not invent a burden rate.** A made-up 22% loading makes every job margin wrong in the same invisible direction.
41- Hours with no job assigned go to unallocated labor, visibly, so the owner can see how much is drifting there. A large unallocated bucket is itself worth reporting.
43---

Job costing

When the business tracks labor to jobs, allocate wages expense by the job hours already captured on the timesheets.

  • Allocate at fully burdened cost when the owner has given a burden rate. Otherwise allocate raw wages and label it as such.
  • Do not invent a burden rate. A made-up 22% loading makes every job margin wrong in the same invisible direction.
  • Hours with no job assigned go to unallocated labor, visibly, so the owner can see how much is drifting there. A large unallocated bucket is itself worth reporting.

Raw lines 35 to 44
45## Reconciliation check
47After posting, verify:
491. Total debits equal total credits
502. Net pay in the entry matches the actual bank debit from the payroll provider
513. Job-allocated hours sum to total paid hours, minus whatever went unallocated
524. The period the entry lands in matches the pay date, not the period end
54Point 4 catches the month-end straddle. A period ending March 31 with an April 4 pay date posts to April cash and, if the owner accrues, March wages. Ask which treatment they use rather than picking one.
56---

Reconciliation check

After posting, verify:

  1. Total debits equal total credits
  2. Net pay in the entry matches the actual bank debit from the payroll provider
  3. Job-allocated hours sum to total paid hours, minus whatever went unallocated
  4. The period the entry lands in matches the pay date, not the period end

Point 4 catches the month-end straddle. A period ending March 31 with an April 4 pay date posts to April cash and, if the owner accrues, March wages. Ask which treatment they use rather than picking one.


Raw lines 45 to 57
58## Accruals
60If the owner accrues wages at month end, the portion of the period worked in the prior month gets an accrual entry and a reversal. Ask once whether they accrue and remember the answer. Most small businesses do not, and adding accruals to books that have never had them makes the year harder to close, not easier.
62---

Accruals

If the owner accrues wages at month end, the portion of the period worked in the prior month gets an accrual entry and a reversal. Ask once whether they accrue and remember the answer. Most small businesses do not, and adding accruals to books that have never had them makes the year harder to close, not easier.


Raw lines 58 to 63
64## What to confirm back
66After posting, report plainly:
68> Posted to QuickBooks, March 20: USD 9,840 wages, USD 812 employer taxes, USD 10,652 cash.
69> USD 7,210 allocated across four jobs, USD 2,630 unallocated.
70> Entry balances and matches the Gusto debit.
72Any of those three failing to line up gets said out loud, not smoothed over.

What to confirm back

After posting, report plainly:

Posted to QuickBooks, March 20: USD 9,840 wages, USD 812 employer taxes, USD 10,652 cash. USD 7,210 allocated across four jobs, USD 2,630 unallocated. Entry balances and matches the Gusto debit.

Any of those three failing to line up gets said out loud, not smoothed over.

Raw lines 64 to 72