Before attempting to upload your accounts using Upload & Share, please ensure the following:
- You have exported the required reports from your package.
- The exported General Ledger and Trial Balance data must each be in .CSV, .XLSX or .XLS file format and can't exceed 100MB in size.
- If your package is not in the list you can select "Other package" and enter manually.
- You can upload these extracts directly to Validis if they have the Minimum mandatory data:
Report Description Mandatory data General Ledger
(GL)A comprehensive accounting report listing all financial transactions at a specific point in time. It systematically records, categorizes, and summarizes all financial activities across accounts, including assets, liabilities, equity, revenue, and expenses. The general ledger provides the foundational data for financial statements, such as the balance sheet, income statement, and cash flow statement For Validis to ingest the report it must include the following data as a Minimum:
- Account Name
- Account Code
- Transaction date
- Transaction Number/ Reference
- Transaction Balance
Additional:
- Transaction Description
Trial Balance
(TB)An accounting report that lists the balances of all general ledger accounts at a specific point in time. The trial balance includes asset, liability, equity, revenue, and expense accounts, displaying their balances before adjustments. For Validis to ingest the report it must include the following data as a Minimum:
- Account Name
- Account Code
- Account Balance
Receivables Ledger (RL) A financial report that provides a detailed record of all transactions related to accounts receivable, including invoices issued, payments received, credits, and outstanding balances for each customer. It serves as a subsidiary ledger to the general ledger, tracking receivable balances at an individual customer level. For Validis to ingest the report it must include the following data as a Minimum:
- Debtor Name
- Transaction Date
- Transaction Balance
- Transaction Number/ Reference
Payables Ledger (PL) A financial report that provides a detailed record of all transactions related to accounts payable, tracking amounts owed by a business to its suppliers or vendors. It serves as a subsidiary ledger to the general ledger, maintaining individual supplier accounts and summarizing outstanding obligations. For Validis to ingest the report it must include the following data as a Minimum:
- Creditor Name
- Transaction Date
- Transaction Balance
- Transaction Number/ Reference
Detailed Aged Receivables A financial report that provides a breakdown of outstanding accounts receivable balances by transaction at a specific point in time. It includes specific details for each debtor, such as transaction numbers, transaction dates, due dates, and amounts outstanding. For Validis to ingest the report it must include the following data as a Minimum:
- Debtor Name
- Transaction Date
- Transaction Balance
- Transaction Number/ Reference
Detailed Aged Payables A financial report that provides a breakdown of outstanding accounts receivable balances by transaction at a specific point in time. It includes specific details for each creditor, such as transaction numbers, transaction dates, due dates, and amounts outstanding. For Validis to ingest the report it must include the following data as a Minimum:
- Creditor Name
- Transaction Date
- Transaction Balance
- Transaction Number/ Reference
- Once you have exported your reports you can follow the guide here to upload the data to Validis.