Tax Sorted - Placeholders

Tax Sorted - Placeholders

​Introduction​
Placeholder is a special set of characters that represents a variable and that are replaced with actual data at runtime. In Tax Sorted the placeholders will fetch your data automatically from sources like Xero report, XPM, etc. and auto-populate the data on the workpapers at the respective place.

Advantages of Using Placeholders

  1. Automating data entry through placeholders will save the time, allowing users to focus on more important tasks rather than repetitive data input.
  2. Placeholders allow for the customisation of workpapers to meet specific needs, ensuring that the collected data from different sources is relevant and useful.
  3. Ensure accuracy by consistently pulling correct data and minimising the need for manual input which finally reduce the workload and the potential for errors.
  4. Placeholders give users clear examples or instructions on what information is required in each field, reducing confusion and errors.

List of Placeholders

By using the below Placeholders, user can bring the details automatically in their workpaper.

Placeholder Name
Source
Description
Related Workpaper
${CLIENT_NAME}
XPM
User can bring the client name in the workpaper.
Most of the Workpapers
${ACCOUNT_NAME} Xero 
User can bring the line item name (Account name) on which user have attached the workpaper. 
Most of the Workpapers
${OPENING_BALANCE}
Xero
User can bring the opening balance of the line item (Account) on which Workpaper has been attached.
Most of the Workpapers
${CLOSING_BALANCE}
Xero
User can bring the closing balance of the line item (Account) on which Workpaper has been attached.
Most of the Workpapers

${GST_RECEIVABLE}
Xero
User can bring the closing balance of the GST Receivable account from the Balance Sheet. 
Integrated Client Account Reconciliation
${GST_PAYABLE} 
Xero
User can bring the closing balance of the GST Payable account from the Balance Sheet.
Integrated Client Account Reconciliation

${GST_ADJUSTMENT_ACCOUNT}
Xero
User can bring the closing balance of the GST Adjustment account from the Balance Sheet.
Integrated Client Account Reconciliation
${SUPERANNUATION_AS_PER_PAYROLL_REPORT} 
Xero
User can bring the Total Superannuation expense as per Payroll Employee Summary report
Superannuation Expense Reconciliation & Superannuation Payable Reconciliation
${PAYMENT_MADE_TO_SUPERANNUATION}
Xero
User can bring the sum of payment entries made of the line item (Account) on which user have attached the workpaper.
Superannuation Payable Reconciliation
${NET_PROFIT}
Xero
User can bring the net profit as per Profit and Loss account in the workpaper.
Most of the Workpapers 
${FINES_PENALTIES}
Xero
User can bring the balance of Fines and Penalty from the Profit and Loss account.
Tax Reconciliation Workpapers
${CURRENT_YEAR_ANNUAL_LEAVE}
Xero
User can bring the closing balance of Annual Leave Provision from Balance Sheet.
Tax Reconciliation Workpapers
${CURRENT_YEAR_LONG_SERVICE_LEAVE} 
Xero
User can bring the closing balance of Long Service Leave Provision from Balance Sheet.
Tax Reconciliation Workpapers
${CURRENT_YEAR_SUPERANNUATION_PROVISION} 
Xero
User can bring the closing balance of Superannuation Provision from Balance Sheet.
Tax Reconciliation Workpapers
${PRIOR_YEAR_ANNUAL_LEAVE}
Xero
User can bring the opening balance of Annual Leave Provision from Balance Sheet.
Tax Reconciliation Workpapers
${PRIOR_YEAR_LONG_SERVICE_LEAVE}
Xero
User can bring the opening balance of Long Service Leave Provision from Balance Sheet.
Tax Reconciliation Workpapers
${PRIOR_YEAR_SUPERANNUATION_PROVISION} 
Xero
User can bring the opening balance of Superannuation Provision from Balance Sheet.
Tax Reconciliation Workpapers
${GROSS_WAGES_AS_ACCOUNTS}
Xero
User can bring the Total wages as per Payroll Employee Summary report.
Wage Reconciliation and Wages Payable Reconciliation.
${PAYMENT_MADE_TO_EMPLOYEE} 
Xero
User can bring the sum of payment entries made of the line item (Account) on which user have attached the workpaper.
Wage Payable Reconciliation







    • Related Articles

    • Essential Settings To Access Tax Sorted

      Introduction The steps shown in this article are all about giving the right access to your staff before they can log into Tax Sorted. You'll need to make sure you've allowed the required access in Xero XPM. Follow the simple guide below to get ...
    • Streamline Workpapers: AI-Powered Data Extraction and Integration from Uploaded Documents

      Introduction With tax Sorted, now create automated workpapers using supporting documents. With just a few clicks, you can upload and process documents, extract data, and generate accurate workpapers with the help of Workpaper Templates and ...
    • Register & Login to Tax Sorted

      Introduction Tax Sorted is your go-to solution for automating the accounting workpaper preparation process, making it easier and faster. We are here to make your accounting workpaper process smoother and easier. This guide will walk you through the ...
    • Add, Remove and Preview Workpapers

      Introduction In Tax Sorted, manage and organise workpapers seamlessly to maintain accurate financial records. This guide offers a detailed walkthrough on how to add, preview, mark as complete, and remove workpapers within Tax Sorted, ensuring clarity ...
    • Roll Forward Workpapers

      Introduction You can Roll forward Workpapers to subsequent years if the same workpaper applies there as well. Follow the steps below to roll forward workpapers and remove roll forward when not required. How to Roll Forward and Remove Roll Forward ...