Workbook
Set it up the way you would in a spreadsheet.
Every accounting product asks an accountant to fill in a setup wizard, and every accountant already has the answer in a spreadsheet. So this is a spreadsheet. Arrow keys move, Enter goes down, =1200+340*2 works, and a block pasted out of Excel lands as a block. What a spreadsheet cannot do is sit underneath: the trial balance tells you it is out by a multiple of nine, the entry refuses to balance, the schedule says whether it ties.
Local onlyPaste from ExcelKeyboard first
- Sheets
- 4
- Network calls
- None
- Stored
- This browser
The setup sheet. Account, name, type, and the two columns — never one signed number. Leave the type on Auto and it is inferred from the code and the name; override it wherever the guess is wrong.
| Row | AAccount | BName | CType | DDebit | ECredit |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 | |||||
| 11 | |||||
| 12 | |||||
| 13 | |||||
| 14 | |||||
| 15 | |||||
| 16 | |||||
| 17 |
What this sheet says
Total debits427,800.00
Total credits427,800.00
Difference0.00
| Type | Debit | Credit | Net |
|---|---|---|---|
| asset | 264,250.00 | 7,000.00 | 257,250.00 |
| liability | 0.00 | 37,600.00 | (37,600.00) |
| equity | 0.00 | 168,300.00 | (168,300.00) |
| revenue | 0.00 | 214,900.00 | (214,900.00) |
| expense | 163,550.00 | 0.00 | 163,550.00 |
The same arithmetic as the toolbelt
Nothing on this page computes for itself. Each sheet reads its cells and hands them to the tested functions the tools and the Chrome extension call, because a trial balance that ties here and fails there is worse than no playground at all.
- Trial balance
- The setup sheet. Account, name, type, and the two columns — never one signed number. Leave the type on Auto and it is inferred from the code and the name; override it wherever the guess is wrong.
- Journal
- One entry, line by line. A line carries a debit or a credit, never both — the check below is the one the ledger will run when you post it.
- Transactions
- The bank feed, as it arrives. Sign carries the direction — a payment out is negative, and parentheses are read as negative too, so a pasted statement column lands the right way up.
- Schedules
- Prepaids, deferred revenue and fixed assets. Each line generates its own roll-forward, and every schedule is checked for tie — the periods must sum to the balance exactly, or it is not a schedule.
The checks come from the toolbelt; the grid conventions — two columns for debit and credit, parenthesised negatives, minor units rounded once — are the ones written down in numerics.