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

To learn more about the process, explore best practices, and make the most of our features, please visit our Knowledge Base. Contact our Support team if you need any assistance.





    • Related Articles

    • 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 ...

    • Register & Login to Workpapers 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 ...

    • 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 ...

    • Manage Wokflow Using Labels

      Introduction Labels are a helpful feature in organising and categorising jobs within Tax Sorted. This article provides a step-by-step guide on how to create and add labels for jobs. How to Create Workflow Labels Step 1: Log in to Tax Sorted and head ...

    • Customising Automated Workpaper Templates

      Introduction Cloning system-generated work paper templates can save time and effort by cloning existing templates for customisation. This article provides a step-by-step guide on how to clone system-generated work paper templates efficiently. How to ...