Learn the essential steps to export your company reports from Jack, enabling you to access all your transactions in various formats and transfer them to your own accounting books for reconciliation.
Table of Contents
- How to Export the General Ledger
- How to Export the Filtered Report
- How to Export the Custom Ledger
- Related Articles
Exporting a report refers to the process of extracting transaction data from the Jack platform in formats like Excel or PDF. This data serves various purposes, including:
Record Keeping: Users can maintain detailed financial records for accounting and auditing purposes.
Data Migration: Transaction data may be exported during system or platform migrations or for use with accounting software.
Reconciliation: Exported data can be compared with external records, like bank statements, to ensure accuracy.
Jack Reports can be exported at any time, though typically done at month-end for reconciliation. The feature is accessible only through the Jack Portal. There are three types of reports available: General Ledger, Filtered Report, and Custom Ledger.
All roles in Jack have the ability to export transactions. However, Employees can only export their own transactions, with the option limited to a filtered report.
How to Export the General Ledger
Log in to your Jack Portal. Navigate to the Transaction page and click on the Export button at the top section of the page, then select the General ledger option.
Choose the file format (XLSX or PDF) and select the date range of all transactions you would like to export.
Click the Export button to download the general ledger. The report will be automatically downloaded and saved to your local computer.
How to Export the Filtered Report
Log in to your Jack Portal. Navigate to the Transaction page and click on the Export button at the top section of the page, then select the Filtered report option.
Choose the item(s) you would like to filter (you can choose more than one filter) and select the date range of all transactions you would like to import.
Click the Export button to download the filtered report. The filtered report will be automatically downloaded and saved to your local computer.
How to Export the Custom Ledger
Log in to your Jack Portal. Navigate to the Transaction page and click on the Export button located at the top section of the page. Then, select the Custom ledger option.
You can export ledger using your preferred accounting software template. Select the template you need for your custom ledger. If the accounting software template you need is not available, kindly “Tell us your needs”, fill the form, and click the ‘Submit’ button. All inputs submitted will be considered for future iterations.
Next, choose from which account you would like to export your transaction (Primary Bank Account or VA Pocket) - this is applicable only for Ultimate users. You can also filter the date range of all transactions you would like to import.
Ultimate
Non-ultimate
Click the Export button to download the custom ledger. The ledger will be automatically downloaded and saved to your local computer. Finally, you can import the custom ledger file into the designated accounting software hassle-free now!
Related Articles
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article