The vSupport template is provided for users who cannot export their Trial Balance (TB), General Ledger (GL), Accounts Receivable (AR), or Accounts Payable (AP) data from their accounting system in a format that meets the Validis Upload & Share requirements.
This template offers a standard structure that you can manually populate to ensure your data is accepted by the Validis ingestion process.
GL Template Columns
Users creating their own General Ledger template must include the following column headers exactly as shown:
| Column | What to enter |
|---|---|
| No | The transaction number. Use the same number on every line that belongs to the same posting, for example a debit line and its matching credit line. |
| Type | The transaction type as recorded in your accounting system, for example journal, payment, or receipt. |
| Date | The date the transaction took place. |
| A/C Code | The account code the transaction is posted to. |
| A/C Name | The account name the transaction is posted to. |
| Reference | The reference number or text your accounting system attaches to the transaction. |
| Details | A description of the transaction. |
| Amount | The value of the transaction, as a single figure. Do not split debits and credits into separate columns, use positive and negative values in this one column instead. |
| Posted Date | The date the transaction was posted to the ledger. |
| Posted User Name | The user who posted the transaction. |
| Period | The accounting period the transaction falls in. |
TB Template Columns
Users creating their own Trial Balance template must include the following three column headers exactly as shown:
| Column | What to enter |
|---|---|
| Code | The account code from your chart of accounts. |
| Name | The account name. |
| Net | The account's closing balance, as a single net figure. |
AR Template Columns
Users creating their own Accounts Receivable template must include the following column headers exactly as shown:
| Column | What to enter |
|---|---|
| Customer Name | The name of the customer the invoice relates to. |
| Customer ID | Your accounting system's identifier for the customer, if available. |
| Document Number | The invoice or transaction number. |
| Document Date | The date the invoice was raised. |
| Due Date | The date payment is due. |
| Amount | The value of the invoice. |
| Currency | The currency of the amount, for example GBP or USD. |
AP Template Columns
Users creating their own Accounts Payable template must include the following column headers exactly as shown:
| Column | What to enter |
|---|---|
| Vendor Name | The name of the vendor the invoice relates to. |
| Vendor ID | Your accounting system's identifier for the vendor, if available. |
| Document Number | The invoice or transaction number. |
| Document Date | The date the invoice was raised. |
| Due Date | The date payment is due. |
| Amount | The value of the invoice. |
| Currency | The currency of the amount, for example GBP or USD. |
This template requires detailed, transaction-level Accounts Receivable and Accounts Payable data (one row per invoice or transaction). Aged summary reports, which group outstanding balances by ageing period as of a specific date, are not supported by this template and will not upload successfully.
Preparing Your Data Using the Template
Export your General Ledger, Trial Balance, Accounts Receivable, or Accounts Payable report from your accounting system in any available format. You will manually copy the relevant information into the template that matches your report type.
Template Completion Guidelines
- Do not alter, rename, or delete column headings.
- Ensure account codes match between TB and GL.
- All date fields (GL: Date; AR/AP: Document Date, Due Date) must use the format dd/mm/yyyy.
- Complete all required fields.
- Do not add extra columns or change the structure of the sheet.
These rules are necessary for the file to validate successfully during upload.
Selecting vSupport for Upload
When using this template, you must select vSupport as the accounting package during the Upload & Share workflow.
- Begin a new Upload & Share engagement.
- When prompted "Which accounting package do you use?", type vSupport into the search bar.
- Select vSupport from the list.