Books and reports

Books: what came in, what went out, what is left

How Books in Chalk adds up each month from payments, clocked hours, receipts, card fees and payouts, and how to get the numbers to your accountant.

Updated By Adrian Gluchowski4 min read

On this page

Books shows one month at a glance: what customers paid you, what the work cost, and what is left over. Nobody types numbers into it. Chalk adds it up from the payments, clocked hours, receipts, card fees and payouts already in the app. It is under Reports, so anyone whose role has Reports on can open it (owner, admin, Office and Bookkeeper by default).

Open Books

  1. Open Reports and press Books at the top.
  2. Use the arrows to step back or forward a month, or press This month to come back.
  3. Read the tiles, then scroll for the detail and the month's receipts.

Months follow your shop's calendar, so a check recorded late on the 31st stays in that month.

What the month shows

LineWhere the number comes from
Collected for the workPayments customers made toward their bills, by card, bank, cash and check, less anything refunded.
Fees customers paidCard or bank fees a customer paid on top of the bill, when you pass the fee on. Only shown when there are some.
LaborClocked hours with no job on them, at each person's rate. Breaks are left out. Hours on a job are paid through Pay and are counted under Payouts.
ExpensesReceipts dated in that month.
Payment feesWhat Stripe kept on card, bank and Klarna payments. Stripe's $1.50 bank account check is billed on Stripe's monthly invoice, so it is not in this line.
PayoutsPay owed or paid that month: hours and day pay on jobs, crew pay, commission, profit shares and other splits.
Left overCollected, plus fees customers paid, minus labor, expenses, payment fees and payouts.

Each tile says how it compares with last month. Below them you get How leftover is counted line by line, Where it went as a chart, Expenses by category, Labor by person, and Expenses this month with each receipt and the job it was for.

Get expenses in

Expenses are receipts. Log them from Pay > Receipts > New expense, with Log an expense on a job page, with Add a receipt on a job (for crew who cannot see prices), or with the Receipt button on a stop on Today, which opens the camera first. Each one has an amount, a category, a date, an optional receipt photo, and either a job or No job, general overhead.

The categories start as Materials, Fuel, Subcontractor and Other. Change them under Settings > Lists > Common expenses, in Expense categories.

Step by step: Log an expense and attach a receipt photo.

Export for your accountant

  1. On a computer, press CSV on Expenses this month to download that month's receipts with date, category, description, amount and job.
  2. For everything in your account, owners and admins open Settings > Data and press Download as spreadsheets under Export everything. You get one CSV per table.

If the month has more receipts than the page shows, the CSV is only what is on the page. The CSV buttons only show on a computer.

QuickBooks

If you keep your official books in QuickBooks Online, owners and admins can connect it under Settings > Connectors > QuickBooks. Chalk then sends customers, sent invoices, payments and, if you pick an expense account, expenses to QuickBooks. It is one way, and card payments still go through Stripe. See Connect QuickBooks Online.

Good to know

  • Books follows the Reports switch under Settings > Team. Someone whose Pay on jobs and quotes is set to "Only their own" sees the month's totals without Labor by person.
  • A bank payment that is still pending is not in Collected for the work until it clears. A check marked as bounced is taken back out. See Bank payments that are pending and Bounced checks.
  • A deposit that is later credited onto the invoice counts once, in the month it was paid.
  • What a client owes (the "Owes" amount on their page) is the unpaid part of their sent invoices. Drafts, written-off and archived invoices do not count toward it, and an archived invoice is not marked past due or chased.
  • Chalk does not connect to your bank, import bank transactions or reconcile accounts. It does not file or work out taxes.
  • Books has no separate sales tax line. Your quotes only add sales tax if you set a rate under Settings > Quotes and invoices > Sales tax, which starts at 0.