What Types of Reports Can I Export from Jack?

Modified on Wed, 05 Jun 2024 at 10:33 PM

There are various types of reports you can export from Jack. This article explores the differences and use cases for three main reports: General Ledger, Filtered Report, and Custom Ledger. We will delve into the details of each report type and highlight the key information available in the exported CSV format.

Table of Contents

The Jack platform empowers users with the ability to export reports, offering valuable insights and data for financial analysis and record-keeping. This feature is particularly beneficial for Bookkeepers to streamline their processes and for Business Owners to review their transaction history. Jack provides three types of reports tailored to different purposes and needs: General Ledger, Filtered Report, and Custom Ledger. Business Owner, Admins, and Bookkeepers can swiftly export these reports anytime from the Jack Portal. Below, we will delve into the details of each report type. For more information on how to export company reports from Jack, please click here.

General Ledger

The General Ledger provides a detailed, full report of all your financial transactions over a specified period of time. The General Ledger consists of three types of sheets:

Main Balance

This comprehensive report lists transactions as either debit and credit in separate columns, offering a clear and organized view of your financial activities. This report contains beginning and end balance information too.

Transaction Detail

This report is a detailed version of the main balance where you can oversee all transaction details such as transaction amount, sent amount, transaction time, transaction fee, recipient bank account and recipient account name, source account, type of transaction (Debit/Credit), and many more.

Corporate Card Summary

This report presents all completed transactions using your corporate cards, both Prepaid and Virtual Cards. You can track all card transaction details such as transaction date, transaction amount, type of transaction (debit/credit), card details (cardholder name, card type), and more.

Who uses the General Ledger?

  • Accountants: To maintain accurate and comprehensive financial records.

  • Financial Managers: To review and analyze the company's financial health.

  • Business Owners: To track and manage their financial transactions.

Common cases for the General Ledger module:

  • Financial Reporting: Generating detailed reports for internal review or external audits.

  • Expense Tracking: Monitoring all expenses, particularly those made with Corporate Cards.

  • Compliance: Ensuring all financial records are complete and accurate for regulatory compliance.

The General Ledger can be exported from the Transaction page on Jack Portal. Click the Export button and select the General Ledger option. You can export it in the XLSX or PDF format. Learn how to export a general ledger in this article.

Filtered Report

The Filtered Report is similar to General Ledger, but it allows you to export transaction data based on specific requirements. When generating this report, you have the option to apply filters to refine the data you want to include. The report is downloadable in CSV format, ensuring compatibility with popular spreadsheet applications.

You can extract filtered report based on:

  • Transaction Type: e.g. International Transfer, Local Transfer, Card

  • Teams: employees within your company that are grouped together

  • Status: the transaction status (Success, In Progress, Refund,...)

  • Source Account: refers to the account that the payment has been made from 

  • Cards: refers to the card transactions that belongs to a specific employee

  • Created By: refers to the user that has created the transaction

  • Categories: refers to which accounting category the transaction is related to

  • Attachment: refers to whether the transaction consist of an attachment or not

The exported Filtered Report contains only a sheet named "Activity". This sheet contains a wide range of transaction details information, enabling a detailed analysis of financial activities. The structure of this report is the same with the Transaction Detail tab in the General Ledger. For instance, if you generate a Filtered Report for Transaction Type = Local Transfer in 2023, you will get the overview of all Local Transfer transactions in detail from January-December 2023 in this report. 

The information included in the report encompasses:

  1. Transaction Category: Categorization of the transaction based on its module or type.

  2. Reference Number: A unique identifier associated with each transaction.

  3. Created By: The individual or user responsible for initiating the transaction.

  4. Created At: The date when the transaction was created.

  5. Paid at: The date when the payment associated with the transaction was made.

  6. Status: The current state of the transaction, such as "Success", "In Progress" or "Failed". You can read more about status in this article.

  7. Description: Additional details or notes of the transaction written by the drafter.

  8. Recipient Bank Account: The bank account details of the transaction's recipient.

  9. Recipient Account Name: The name associated with the recipient's account.

  10. Source Account: The account from which the transaction was made, such as “Main balance”, “Danamon Balance”, “Card” or “Direct Payment”.

  11. Debit/Credit: Indicates whether the transaction involved a debit (denoted by D) or credit (denoted by C) to the source account.

  12. Transaction Amount: The original amount associated with the transaction.

  13. Sent Amount: The amount sent to the recipient after accounting for any fees or conversions.

  14. Transaction Fee: The fee charged for processing the transaction.

  15. Destination Country: The country where the recipient's bank account is located. You will only see this information in an international transfer transaction.

  16. Destination Currency: The currency used in the recipient's country. You will only see this information in an international transfer transaction.

  17. Destination Amount: The equivalent amount in the recipient's currency. You will only see this information in an international transfer transaction.

  18. Notes: Any additional remarks or comments attached to the transaction.

  19. Category: The accounting category that is related to the transaction (e.g. Marketing, Procurement, Travel expenses, etc.)

  20. Account Code: The code that is linked to the transaction category

  21. Attachments: The attachment link of the transaction, if any

Who uses the Filtered Report?

  • Analysts: To extract specific data for financial analysis.

  • Project Managers: To generate reports based on project-specific transactions.

  • Auditors: To review transactions that meet certain criteria.

Common cases for the Filtered Report module:

  • Customized Reporting: Creating tailored reports for specific projects, departments, or time periods.

  • Data Analysis: Extracting relevant data for financial analysis and decision-making.

  • Audit Preparation: Preparing specific transaction data for audits and reviews.

The Filtered Report can be exported from the Transaction page on Jack Portal. Click the Export button and select the Filtered Report option. Learn how to export a filtered report in this article.

Custom Ledger

The Custom Ledger facilitates the easy export of financial data in formats compatible with various accounting software. This feature allows you to seamlessly export and import their financial data into your accounting software without the need for manual adjustments. The report is downloadable in CSV format, ensuring compatibility with popular spreadsheet applications.

When you export the custom ledger from Jack, the default report layout will look like this.

Currently, we only support Xero accounting software. However, if you don’t use Xero and would like to export a report using your preferred template, please let us know your requirements here.

If you have exported Xero ledger from Jack, the next step is to import the file into your Xero account. Follow these simple steps:

  1. Login to Xero and Access Bank Accounts

    1. From the Xero dashboard, navigate to the Accounting menu in the main navigation bar.

    2. Select the Bank accounts option from the dropdown menu.

  1. Manage Account

    1. Find the bank account into which you want to import the statement.

    2. Click on the Manage Account button located next to the bank account name.

  2. Click the Import a Statement button.

  1. Upload the File:

    1. In the “Import a Statement” section of Xero, click on the Browse or Select File button.

    2. Navigate to the location on your local computer where the exported file from Jack custom ledger is saved.

    3. Select the file and upload it to Xero.

  1. Verify column mappings

    1. Xero will display the columns from your uploaded file.

    2. Ensure each column (e.g. Date, Amount, Description) is correctly mapped to the corresponding field in Xero.

  1. Review and Complete Import

    1. Look over the preview of the transactions to make sure everything is correct.

    2. Click the Complete Import button to finalize the import process.

    3. Xero will now import the transactions into the selected bank account.

Who uses the Custom Ledger?

  • Accountants: To integrate financial data into their preferred accounting software.

  • Financial Consultants: To transfer client data into different accounting systems.

  • Business Owners: To ensure their financial data is accurately reflected in their accounting software.

Common cases for the Custom Ledger module:

  • Data Integration: Exporting data from our platform and importing it into preferred accounting software.

  • Reconciliation: Ensuring financial records in our platform match those in the accounting software.

  • Efficiency: Reducing manual data entry and minimizing the risk of errors.

The Custom Ledger can be exported from the Transaction page on Jack Portal. Click the Export button, select the Custom Ledger option, and choose which accounting software you would like to import. Learn how to export a custom ledger in this article.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article