The accounting journal
The accounting journal turns a payroll batch into debit and credit lines for your general ledger, so finance can post payroll without rebuilding it from a spreadsheet. You set up a journal template once in Settings, mapping each payroll figure to an account and a side, then run it against each batch and export it as CSV or Excel, or send it straight to QuickBooks or Xero.
Where:
- Templates: Payroll › Settings › Payslips & Accounting › Accounting Journal Templates
- Running the journal: Payroll › Dashboard › View Reports › Create Report › Others › Accounting Journal
You need:
- General Reports (or Create/View Payroll Reports) with write access to set up templates
- General Reports to run and export the journal
- Payroll settings access as well, for the QuickBooks and Xero buttons to appear
Before You Start
Get the chart of accounts from finance. The journal has to match their ledger exactly.
Agree the level of detail. One line per contribution, or one for all contributions? More lines make reconciliation easier and the ledger noisier. That is finance's call.
Connect QuickBooks or Xero first if you will export to them. With a connection, the Account field becomes a search of your real chart of accounts.
How to set up a journal template
- Go to Payroll › Settings › Accounting Journal Templates.
- Select New template, enter the Name of the Report Template and select Save. Names must be unique.
- Pick the template under Select template. Its Journal Items table shows Name, Entry, Date, Id and Memo.
- Select Add to create a journal line, and fill in:
- Name — the line's name, unique within the template, such as "Salaries expense". - Account — the ledger account. With QuickBooks or Xero connected, search and pick from their chart of accounts; otherwise type it. - Date — the date stored on the line. - Id — your own GL code or line ID. It becomes the GL Number row in the Financial report. - Entry — Debit or Credit. - Memo — optional text, up to 512 characters. - Payroll Item — the figure this line posts, from the list below.
- To post only part of a figure, choose a Detailed Item, for example one named allowance inside Subtotal Allowances.
- To combine figures, select + and add rows of Plus or Minus with another Payroll Item. Select − to remove a row.
- Tick Show Details to break the line into its components, one row per activity or other payment name, when the item supports it.
- Select Save. Repeat for every line until each payroll figure has a debit and a credit side.
Choosing a Detailed Item or adding rows turns the line into a Custom item, which KAMI calculates from your formula. To remove a line, open it and select Delete. Delete on the template card removes the whole template, and cannot be undone.
Payroll items you can map
| Payroll Item | Posts |
|---|---|
| Total Wages, Subtotal Basic Salary, Basic Monthly Wage | Pay for time worked, and the basic wage |
| Subtotal Fixed Allowances, Subtotal Allowances, Subtotal De Minimis, Subtotal Non Taxable | Allowance groups |
| Subtotal Commissions, Subtotal Bonus, Subtotal Bonus (Non-Billable), Subtotal Encashment, Subtotal Termination | Variable and one-off pay |
| Subtotal Loan, Subtotal Union Dues, Subtotal Attendance Policy, Subtotal Wage Adjustment, Subtotal Expenses, Subtotal Others, Subtotal Others (taxable) | Deductions, reimbursements and adjustments, by other payment type |
| Subtotal Tax Gross Up, Subtotal Contribution Gross Up | Grossed-up tax and contributions paid by the company |
| Each contribution, as (ER), (EE) and (Total) | Employer share, employee share, or both, shown under your contribution names (for example SSS (ER)) |
| Taxes Payable | Tax withheld |
| Total Payable | Net pay to employees |
| Total Deductible Expenses, Total Deductible Contribution EE | Deductible expenses and employee contributions |
Show Details works for Total Wages and the Subtotal items for allowances, commissions, bonus, non taxable, loan, attendance policy, wage adjustment, gross-ups, expenses, termination, encashment, others, de minimis and union dues.
How to run the journal
- Select View Reports › Create Report › Accounting Journal. The Journal Entry page opens.
- Under Payroll Batch, select one or more batches.
- Under Template, choose your journal template. The journal generates straight away.
- Choose Summarize by: All (default), Cost Centre, Subsidiary, Department or Employment Type. Each line then splits into one row per value.
- With two or more batches and All, turn on Aggregate Batches to add the batches into one set of lines, or off to show each batch separately.
- Narrow it with the filters for Department, Subsidiary, Cost Centre, Employment Type or profile group, or search by line name.
- Check the total bar shows Debit and Credit equal and the chip says Balanced.
- Select Export: Export CSV, Export XLSX, or Financial report, a pivoted Excel file with one row per batch or group, one column per line and a GL Number row. For the Financial report, choose whether the column headings use the Payroll Property or the Journal item name.
Lines with a zero amount are left out. The journal includes every payslip in the selected batches, whatever its status.
How to export to QuickBooks or Xero
- On the Journal Entry page, select QuickBooks or Xero.
- If your company has more than one connection, choose the organisation.
- Under Before you export, KAMI checks that debits and credits balance and that every account exists in QuickBooks or Xero. Select Show how accounts match to see each mapping.
- Set the Entry date, usually the pay date. The memo reads "Payroll Journal" followed by the batch names.
- Select Export to QuickBooks or Export to Xero. On success, select Open in QuickBooks or Open in Xero to see the entry.
The export sends one journal entry with one line per journal item. Summarize by splits are not sent.
Tips
- Check it balances every period. Unbalanced means a figure has no matching debit or credit line.
- Reconcile the journal against the batch total. If they differ, an item is unmapped.
- Review the template whenever you add an other payment type. New types are not mapped for you.
- Export each batch to QuickBooks or Xero once. Exporting again creates a second entry.
- Run it in parallel for the first two periods and compare with your manual posting.
Troubleshooting / FAQ
Q: The journal says Unbalanced. A line is missing or on the wrong side. Every amount you post as a debit needs a matching credit.
Q: The QuickBooks or Xero export says an account can't be used. The account name or number on the line no longer matches your chart of accounts. Edit the line and pick the account again.
Q: I can't see the QuickBooks or Xero button. Your company has no connection, or you lack payroll settings access.
Q: A new allowance is missing from the journal. Add it to the template, either through its Subtotal item or as a Detailed Item.
Q: Do past journals change when I edit the template? The journal is calculated each time you run it, so running an old batch again uses the template as it is now. Keep the files you posted.