Three ways to get transaction data out of Validis
There are several ways to extract data from Validis for sampling. Which one you want depends on how much data you need. The three below run from everything, to everything for one account.
- GL Transactions, for every journal entry in the period.
- General Ledger Report, for all account movements as a downloadable pack.
- Trial Balance drill-down, for one account at a time without the rest of the data.
Method 1: GL Transactions
This gives you a complete journal entry listing, one row per line of each journal.
Select General Ledger in the menu on the left, then the GL Transactions tab. Set the period above the report, then select Download Report to export it to Excel, where you can filter and apply your own analytic tools.
On screen the listing shows No, Type, Date, A/C Code, A/C Name, Reference, Description and Amount. Each journal appears as several rows sharing the same number, one per account it touched.
Method 2: General Ledger Report
The General Ledger Report covers all account movements and downloads as a zip file.
Select Exports in the menu on the left, open the Standard Reporting Packs tab, then expand General Ledger Report. Choose the period from the dropdown and select Generate.
The generated report is listed underneath with its Year, Period and Generation Date. Select the download icon under Actions to save it. The icon beside it regenerates the report if your client has uploaded newer data since.
General Ledger Report: choose the period, then Generate.
Method 3: Trial Balance drill-down
Where you want to sample a single account without pulling everything, work down from the Trial Balance.
Step 1
Open the Trial Balance and set the period
Select General Ledger in the menu on the left, then the Trial Balance tab. Choose the period you want above the report.
Trial Balance, and the period selector.
Step 2
Find the account
The Trial Balance lists every account with its Code, Name, Debit, Credit, COA Category and COA SUB-Category. Use the search box above the report to find an account by name, or select it directly from the list.
Search for the account, or select it from the list.
Step 3
Open the account summary
Account Summary opens, showing the account's Opening Balance, Movement and Closing Balance. The breadcrumb above it reads Trial Balance then Account Summary, so you can step back at any point.
Step 4
Open the transactions
Select the Movement figure to open the Transaction Data Viewer, which lists every transaction making up that movement. Download Report exports it to Excel for further analysis.
Please note
An account with no movement in the period shows a dash rather than a figure, and there is nothing to open. Pick an account that moved.