Rather than uploading Cash Journal reports directly extracted from ERP Systems (like a QuickBooks General Ledger List) you can upload a list of cash transactions via our Valid8 excel template (CSV format).
This process follows three steps:
- Download the Cash Journal extract template
- Update the template with your transactions
- Upload the Cash Journal
Download the Cash Journal Extract Template
Download this CSV file - Valid8 Cash Report Template. This is an excel (CSV) template with the required columns for uploading Cash Journals.
Update the Template with your Transactions
Prepare your data for loading in the template file using the 8 columns provided.
- Copy (or type) your data into the columns.
- Bank account - required. Name of the GL Cash Account. This will be the name used when we automatically create the account that these transactions belong to.
- Transaction date - required. Date that the cash transaction was reflected in the accounting system.
- Transaction type
- Num
- Name
- Description
- Amount - required. Amount of the cash transaction reflected in the accounting system. Debit amounts as positive amounts and credit amounts as negative amounts.
- Balance. Most Cash Journal reports have a running balance of the account. Valid8 does not use this field within it's matching process.
- Save the output as CSV (UTF)
Upload the Cash Journal
-
On the process map, click the Load Evidence Tile and select the Cash Journal Extract option (under the Accounting Data Import group).
- Click the Next button, then click the Start Extraction button.