Payroll Journal
The Payroll Journal turns a posted payroll cutoff into a journal entry your accountants can book: earnings, allowances, employer statutory shares, statutory payables, deductions and net pay, each on an account you choose from your chart of accounts and each debit line carrying a cost centre. You can adjust any line, then finalize the journal to post it to the general ledger. The Excel voucher download stays available.
Accessing the Payroll Journal
- Click HR in the sidebar
- Open Payroll, then select Payroll Journal
The page has four tabs: Journals, Account map, Cost centres and Rates & currency. You need the Payroll Journal permission to see the page; ask an administrator if it is missing from your sidebar.
Before You Start: Set Up the Account Map
On the Account map tab, choose from the chart of accounts the account that each pay component posts to. Components are grouped as Earnings, Allowances, Employer statutory shares, Accruals, Statutory payables, Deductions and Net pay. Click Save account map when done.
Under Allowances you will also find a Tax gross-up (company-paid) row. It is the expense account for the company-paid tax added to the pay of an employee on fixed net pay (see Company-Paid Tax (Gross-Up)). The company-paid tax on a grossed-up allowance is not on this row — it posts to that allowance's own row.
The map starts empty, so nothing posts until you choose accounts. Under Fallback accounts you can optionally set a fallback account for each group; it is used for any item in that group that has no account of its own. A deduction sub-type uses its parent's account, and each row tells you when it is using a fallback or an inherited account. Net pay and the optional accrual and unrecovered-deduction accounts must be mapped directly. A row showing no account and no fallback means journals containing that item cannot be generated.
With an empty account map, no journal is generated; the Journals tab offers Open the account map. A component that has no account and no fallback blocks the journal. Fill in the missing account, then generate again.
If a payroll group pays a fixed cash portion (see Payroll Group), you can map Net pay paid in cash to the account the cash is drawn from. Salaries payable are still credited for the full net pay in total; the cash part simply appears as its own credit line, so the cash withdrawal reconciles to the Cash payout sheet. Leave it unmapped and the journal stays exactly as it was.
If your company has no chart of accounts set up in Treasury → Accounting, the Account map and Journals tabs show a banner saying so, and no payroll journal is generated until a chart exists. An account that was later removed from the chart is flagged so you can choose another.
Mapping Cost Centres
Cost centres are maintained in Treasury → Configuration → Cost Centres. On the Cost centres tab, click Add mapping to assign one of them to a Department, Branch or Employee; the journal's debit lines carry it into the general ledger. A department here is the employee's role group. The Manage cost centres in Treasury link takes you to the list; if there are no active cost centres you are asked to add them in Treasury first.
Each mapping shows a Status: Linked, Inactive in Treasury or Deleted in Treasury. Re-assign any mapping that is not Linked. Without a mapping, the employee's department name (otherwise the branch name) is used only if it matches a Treasury cost centre's code or name. When several mappings could apply, an employee mapping beats a department mapping, which beats a branch mapping.
An employee's own cost centre
Most companies set an employee's cost centre on the employee record instead: open Employee Records, choose Edit, and use Cost centre under Payroll attribution on the Work tab (it can also be filled from the import template's Cost Centre column, and filtered and shown on the employee list). It is the same employee mapping you see here, so there is one place of truth. The payroll, disbursement and recharge journals all group an employee's costs by it first and fall back to the department only when the employee has none.
The journal reads the cost centre when it is generated, so it is the value in force when you generate the cutoff. If an employee transfers, change their cost centre and generate the journal again to re-attribute the cutoff.
For example, two people in the Admin department, one assigned cost centre 50-30 and one with none, are booked as separate groups: the first person's pay under 50-30, the second under the Admin department's cost centre. The group totals add up to the same amounts as the payroll register, which also carries a Cost Centre column and a subtotal per cost centre when your company uses employee cost centres.
Second Currency and Monthly Rates
The Rates & currency tab lets the journal show a second currency (for example USD) beside your company's own currency.
810101-000-20).Click Save settings, then use Add rate to key a monthly rate (how many units of your currency one foreign unit buys). If you do not key a rate for a month, the system's exchange-rate data for that month is used. Resolve rate under Check a month's rate shows which rate a given month will use, and where it came from.
Generating and Downloading a Journal
- Pick the cutoffOn the Journals tab, choose a cutoff under Posted cutoff. Cutoffs that already have a draft are marked "draft exists".
- GenerateClick Generate journal. A journal with a reference number is created from the posted payroll as a Draft.
- Check the cost-centre warningIf your company assigns cost centres to employees, the journal lists the employees who were not grouped under their own cost centre (they fell back to the department or branch cost centre, or ended up with none). Assign their cost centre on the employee record and generate again, or accept the fallback.
- Review and adjustSelect a journal to see its lines. Select a line to change its Account, Cost centre (picked from your Treasury cost centres) or Description. Use Edit date / rate to change the Entry date, override the rate for this journal only, or add Notes. Lines you changed are marked edited.
- Finalize and postClick Finalize and post to GL when the journal is right and confirm. One voucher is posted to the general ledger (once only, even if you retry), the journal can no longer be edited, and it shows a Posted to GL badge with an Open the voucher in Accounting link. Use Download Excel at any time to get the voucher as a file. If the voucher is later reversed in Accounting, the Journals list and the journal's detail show a red Reversed badge in place of Posted to GL, so you can tell which journals are still on the books and which cutoffs can be generated again.
Use Delete draft to throw a draft away; you can generate it again from the cutoff at any time.
A company can require a second pair of eyes: on the Rates & currency tab, switch on A different person must finalize (changing it needs the company settings permission). From then on, whoever generated or edited a draft can never finalize it, even with full access: another holder of the Finalize permission must do it. The journal's detail shows who prepared it and, once posted, who approved it and when. A draft nobody is on record as having prepared is also refused: generate it again, then ask someone else to finalize.
A journal that does not balance cannot be downloaded — fix the lines first. If rounding leaves a small difference, it is absorbed by the net pay line and the page tells you the amount.
To correct a journal that is already posted, reverse its voucher in Accounting and generate the cutoff again. If expense lines have no cost centre, the page warns you how many; map them on the Cost centres tab or edit the lines.
Cost-centre mappings are also used when payroll disbursement lines are assigned a cost centre, so you maintain them in one place.
Related Topics
- Payroll Center — where a cutoff becomes posted
- Debit Notes (Inter-company Recharge) — recharging seconded employees' salary, with its own journal
How It Connects
Set up first
- Cost Centres (Treasury) — the cost-centre list you map departments, branches and employees onto; posted journals carry them into the ledger.
- Allowance — each allowance type is a row of the account map.
- Deduction — each deduction type is a row of the account map.
Gets its data from
- Payroll Center — a journal is generated only from a posted cutoff.
Feeds into
- Debit Notes — reuses this page's account map, cost-centre mappings and monthly rates.
- Disbursements — uses the same cost-centre mappings when a disbursement line has no cost centre.