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

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

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

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

    • Job Status Updates in Workpapers Sorted

      Introduction This article guides you through the process of changing the status of jobs created workpapers added in Workpapers Sorted. It provides a brief description of each job and workpaper status and explains how you can update the status of any ...

    • Data Authentication: Workpapers Sorted - Xero

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