Transactions are any money in or out on an agent ledger that isn't tracked as part of a settlement commission, such as desk fees, marketing costs, bonuses, reimbursements or corrections.
This article covers how to add a transaction, how to choose between an earning and a deduction, how to stop withholding tax being taken from a transaction that isn't income, and how to enter a negative amount to correct an earlier transaction.
How Do I Add a Transaction?
- Go to Financials > Agent Ledgers and open the agent's ledger.
- Click Add transaction.
- Choose Add Transaction.
- Check the Date.
- Select the Type. If the type has been set up with defaults, the earning or deduction, amount, description and account fill in for you. You can still change any of them.
- Enter or check the Description.
- Enter or check the dollar figure in Amount (inc GST).
- Choose or check Earning or Deduction.
- Check the Account, and whether GST Free (GST not applicable) is ticked.
- If this is an earning that isn't income (such as a loan or reimbursement), tick Exclude from withholding tax. See the section below on withholding tax.
- Click Add to Ledger.
To set up your transaction types so they fill in automatically, see - Agent Ledgers: Setting Up Transaction Types.
You can also add a transaction during a pay run, from the same Add Transaction window in Step 2. See - Commissions Pay Run: Step 2 - Edit Commissions.
❗ Please Note: You need to choose Earning or Deduction every time, unless your transaction type sets it for you. If neither is selected, you'll see "Select either Earning or Deduction" and the transaction won't save. A Description is also required.
What's the Difference Between an Earning and a Deduction?
- Earning - money paid to the agent, such as a bonus, an extra commission payment, a loan or a reimbursement.
- Deduction - money taken from what the agent is paid, such as a desk fee or marketing cost. Deductions show in brackets on the ledger, for example (300.00).
How Do I Stop Withholding Tax Being Taken From a Transaction?
Not every earning on an agent's ledger is income. A loan to an agent, a float, or a reimbursement for something they paid for personally (like a builder's report) is still an earning, but it shouldn't have withholding tax taken out of it. Marking it as exempt means the agent is paid the full amount.
- Add a new transaction, or open an existing one and choose Edit.
- Make sure Earning is selected.
- Tick Exclude from withholding tax. It sits beside GST Free (GST not applicable).
- Click Add to Ledger (or Save if you're editing).
The transaction stays an earning on the ledger and the salesperson invoice, and still posts to the same account. It's only left out of the withholding tax calculation. The withholding figure on the salesperson invoice, the pay run summary, Xero and the iPayroll export all reflect the exemption.
❗ Please Note:
- This only makes a difference if a withholding tax rate is set on the agent's ledger.
- Only earnings can be excluded. If you tick Exclude from withholding tax on a deduction, you'll see "A deduction cannot be excluded from withholding tax; the exemption applies to earnings only."
- You need to tick it on each transaction. It isn't set automatically by the transaction type or account.
How Do I Check Which Transactions Are Exempt?
- On the ledger - the transactions list has a wht exempt column. Exempt transactions show Exempt, and all others are blank.
- On the salesperson invoice - a wht exempt column appears with the same Exempt marker, but only when that invoice includes an exempt earning.
How Do I Correct an Earlier Transaction?
To correct part of an earlier transaction, add a new transaction with a negative amount in the same category. For example, to refund $100 of a $300 desk fee, add a Deduction of -100. It stays a deduction and reduces the deductions total, rather than showing as an earning.
For the full steps and how it shows on the ledger, invoice and in Xero, see - Entering Negative Amounts and Refunds.
To cancel a whole transaction instead, use Reverse.
❓ FAQs
Why won't my transaction save?
Check you've chosen Earning or Deduction and entered a Description. Both are required. If you've ticked Exclude from withholding tax, make sure the transaction is an earning, as deductions can't be excluded.
Can I enter a negative amount?
Yes. Type a minus sign before the amount to correct an earlier earning or deduction. See - Entering Negative Amounts and Refunds.
I ticked GST Free to stop withholding tax being taken. Why did the tax go up?
Withholding tax is worked out on the amount excluding GST. Ticking GST Free means no GST is taken off first, so the amount being taxed is higher. To stop withholding tax being taken, untick GST Free (unless the transaction really is GST free) and tick Exclude from withholding tax instead.
What does "Mark as Withholding Tax" on a chart of account do?
That setting only chooses which Xero account the withholding tax line posts to. It doesn't change what gets taxed. To stop tax being taken from a transaction, use Exclude from withholding tax.
Will marking a transaction as exempt change past pay runs?
No. Transactions and pay runs from before you ticked the box keep their figures, and nothing is recalculated.
Too much withholding tax was taken on a pay run that's already been processed. Can I get it back?
No. Exclude from withholding tax only affects transactions that haven't been processed yet. Once a pay run is processed, the tax already withheld isn't returned by adding or changing a transaction.
Can I set a transaction type to always be exempt from withholding tax?
Not at the moment. You need to tick Exclude from withholding tax on each transaction.
I don't have any transaction types to choose from. What do I do?
Ask your Rex admin to set them up. You'll need the Chart of Accounts manage privilege to add or edit them. See - Agent Ledgers: Setting Up Transaction Types.
I picked a transaction type and nothing filled in. Why?
That type hasn't been set up with defaults yet. An admin can add them in Settings > Custom Values & Mailing Lists > Value Lists > Agent Ledger Transaction Category. See - Agent Ledgers: Setting Up Transaction Types.