Workpapers Sorted - Placeholders

Workpapers 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 Workpapers 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

    • Streamline Workpapers: AI-Powered Data Extraction and Integration from Uploaded Documents

      Introduction With Workpapers 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 ...

    • Register & Login to Workpapers Sorted

      How to login using Xero Step 1: Click on Sign in with Xero to login using your Xero credentials. Step 2: On the appearing page, enter your Xero Email ID and Password and click on Login. Step 3: Enter Authentication code and Confirm. Alternately you ...

    • How to Disconnect the Workpapers in the Workpapers Sorted

      Introduction- If you see the following error while connecting a client to Xero This indicates that the organisation is already linked. To reconnect or update the integration, you’ll first need to disconnect the existing connection. Steps to ...

    • Interlinking Workpapers

      Introduction Workpapers Sorted now makes it easier to manage workpapers by allowing you to link existing workpapers from the same or other jobs as read-only references. Any updates made to the original workpaper will automatically show wherever it’s ...

    • 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 the roll forward when not required. How to Roll Forward and Remove Roll Forward ...