Tax Sorted - Placeholders

Tax Sorted - Placeholders

Introduction

Placeholders are a special set of characters that represents a variable and that are replaced with actual data at real-time. In Tax Sorted the placeholders will fetch your data automatically from sources like Xero report, Xero ledger and XPM 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 Placeholders listed below, a user can bring the details automatically in their workpapers. (Scroll across to view the table.)

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 login to 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, you can 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 ...

    • Data Authentication: Tax Sorted - Xero

      Introduction Discover how the seamless integration between Xero and Tax Sorted can streamline your accounting processes. This integration ensures your financial data is accurate, up-to-date, and easy to manage, making Tax Sorted the ideal solution ...

    • FYI Integration - Tax Sorted

      Introduction With this newly added feature, we have developed the functionality to Upload Documents directly from FYI Docs into Tax Sorted and Save the Workpaper File into FYI Docs once generated. Configuration Step 1:- After logging in to the Tax ...

    • Register & Login to Tax Sorted

      Introduction Tax Sorted is your go-to solution for automating the workpaper preparation process, making it easier and faster. We are here to make your workpaper process smoother and easier. This guide will walk you through the process of logging in ...