​Neat - The Neat Experience! Reporting in the Transactions Grid

Reporting in the Transactions Grid

Create expense reports, tax category reports, and spending reports within the Transactions grid in Neat. Once created, it will be added to your library and you can download your report to share it with anyone who may need to view it for accounting or record keeping purposes.

Please Note: For the following you will need to be logged in to the Neat web app.

 

FAQs

 

Reports Overview

The following briefly describes each type of report you can create in Neat:

Expense Report – Begins with a summary cover page (includes category subtotals and grand total), provides detailed column information from your grid, and includes the scanned images for your items. You cannot include locked items in an expense report.


Tax Category
– Groups your items with subtotals along with a grand total of all groups and also lists the date, category, total amount, and % of total for each item. Tax category reports allow you to add a subtitle and additional filters to your report. You can also include images in your tax category report and choose to see 1, 2, or even 4 images per page. You can include locked items in a tax category report.


Spending Detail
– Provides a subtotal for each grouping and includes the % of the subtotal amount for each item within a group. Spending detailed reports allow you to add a subtitle and additional filters to your report. You can also include images in your spending detail report and choose to see 1, 2, or even 4 images per page. You can include locked items in a spending detail report.


Spending Summary
– Breaks down the number of expenses for each group in addition to a subtotal for each grouping and includes the % of the subtotal amount for each item within a group. Spending summary reports allow you to add a subtitle and additional filters to your report. You can also include images in your spending summary report and choose to see 1, 2, or even 4 images per page. You can include locked items in a spending summary report.

 

Can I create a report by selecting individual transactions?

Yes! you can select multiple transactions from the Transactions Grid to create your report as well. You would simply choose the bank account and transaction line items that you would want included in your report before clicking Create Report at the bottom.

 

How do I create an expense report?

An expense report will show you a detailed summary of all the expenses included in the report.

Please note: Expense reports will only include reimbursable bank and credit card transactions.

  1. First select Transactions from the menu on the left.
  2. Then choose Create Report at the bottom left of the transactions grid.
  3. Be sure to click on Expense to begin creating your report. Then click on Next Step in the bottom right of the pop up window.
  4. The next window will allow you to set filters to refine your report. You are able to choose from Date, Account, Vendor and Reconciled.
  5. Once you have your filters set, you can click Next Step to finsih out your report. Here you can add a Title (a required field), description of your report, notes and comments, select a folder to store your report. You can also group, sort and include images in your report.
  6. Once you finish adding your final touches to the report, click on Create in the bottom right corner then your report will be brought to your report details.
    Please note: If you receive a Report Failed window, that is due to your filters only returning pending transactions or the filtered transactions are locked or not marked as reimbursable when creating an expense report.

 

How do I create a tax category report?

A tax category report will organize your items by your selected tax categories and provide subtotals for each category as well as a grand total of all items included in the report.

  1. First select Transactions from the menu on the left.
  2. Then choose Creat Report at the bottom left of the transactions grid.
  3. Be sure to click on Tax Category to begin creating your report. Then click on Next Step in the bottom right of the pop up window.
  4. The next window will allow you to set filters to refine your report. You are able to choose from Date, Account, Vendor and Reconciled.
  5. Once you have your filters set, you can click Next Step to finsih out your report. Here you can add a Title (a required field), description of your report, notes and comments, select a folder to store your report. You can also group, sort and include images in your report.
  6. Once you finish adding your final touches to the report, click on Create in the bottom right corner then your report will be brought to your report details.

 

How do I create a spending detail report?

A spending detail report will organize the purchases included in the report by group. It will provide subtotals for each group you selected (vendor, expense category, payment type, client, or project) as well as provide a grand total of all items.

  1. First select Transactions from the menu on the left.
  2. Then choose Creat Report at the bottom left of the transactions grid.
  3. Be sure to click on Spending Detail to begin creating your report. Then click on Next Step in the bottom right of the pop up window.
  4. The next window will allow you to set filters to refine your report. You are able to choose from Date, Account, Vendor and Reconciled.
  5. Once you have your filters set, you can click Next Step to finsih out your report. Here you can add a Title (a required field), description of your report, notes and comments, select a folder to store your report. You can also group, sort and include images in your report.
  6. Once you finish adding your final touches to the report, click on Create in the bottom right corner then your report will be brought to your report details.

 

How do I create a spending summary report?

A spending summary report provides an overview of your expenses by the grouping you select. Choose from vendor, expense category, payment type, client, or project. This report includes subtotals for each group as well as a grand total of all items included in the report.

  1. First select Transactions from the menu on the left.
  2. Then choose Creat Report at the bottom left of the transactions grid.
  3. Be sure to click on Spending Summary to begin creating your report. Then click on Next Step in the bottom right of the pop up window.
  4. The next window will allow you to set filters to refine your report. You are able to choose from Date, Account, Vendor and Reconciled.
  5. Once you have your filters set, you can click Next Step to finsih out your report. Here you can add a Title (a required field), description of your report, notes and comments, select a folder to store your report. You can also group, sort and include images in your report.
  6. Once you finish adding your final touches to the report, click on Create in the bottom right corner then your report will be brought to your report details.

 

My report is taking a long time to generate, is something wrong?

If your report is taking a long time to generate, than it is probably because you chose to include images in your report. Reports will take a longer time to generate if images are included because behind the scenes, the Neat Cloud has to build out your report, locate all the images, re-size the images if needed and then generate them on your report.

If your report is taking a long time to generate, then we recommend closing the report and re-opening it. Reports are not refreshed in the item report view, so you need to close the report and re-open it for it to refresh.

Please note: When the Report Wizard is launched from the Add Items menu or the Reports Grid, users will be required to select which data they would like to use before creating the report. This option will not appear if the user is creating a report right from the Transactions Grid.

How did we do?


Powered by HelpDocs

Powered by HelpDocs