Transactions Reporting

Updated 1 week ago by klorisa coleman

Please Note: You must be on an active Neat Books subscription or a Neat Complete subscription in order to take advantage of the features in this article.

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.

Classic Reporting FAQs

Accounting Reporting FAQs

 

What is Classic Reporting?

Classic reporting allows you to generate standard reports about your business's income, expenses, and tax information.

What are the different types of classic reports?

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.


Sales Tax
- Reports the sales tax for selected items along with the date, category, subtotal, and % of total for each group; concludes with a grand total of all items in the report. Sales tax reports allow you to add a subtitle and additional filters to your report. You can also include images in your sales tax report and choose to see 1, 2, or even 4 images per page. You can include locked items in a sales tax report.

 

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 Reports from the menu on the left.
  2. Be sure to click on Expense to begin creating your report.

  3. The next window will ask you to choose between Transactions and Receipts/Mileage. Choose Transactions.

  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 finish 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 Reports from the menu on the left.
  2. Be sure to click on Tax Category to begin creating your report.

  3. The next window will ask you to choose between Transactions and Receipts/Mileage. Choose Transactions.

  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 finish 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 Reports from the menu on the left.
  2. Be sure to click on Spending Detail to begin creating your report.
  3. The next window will ask you to choose between Transactions and Receipts/Mileage. Choose Transactions.

  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 finish 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.
    Spending Summary Step 2
  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 Reports from the menu on the left.
  2. Be sure to click on Spending Summary to begin creating your report.
  3. The next window will ask you to choose between Transactions and Receipts/Mileage. Choose Transactions.

  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 finish 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 sales tax report?

  1. First select Reports from the menu on the left.
  2. Be sure to click on Sales Tax Report to begin creating your report.
  3. The next window will ask you to choose between Transactions and Receipts/Mileage. Choose Transactions.

  4. The next window will allow you to customize your report using various filters including Date, Vendor, Folder, Category, etc. Once your filters are set, click on Next Step.

  5. Once you click Next Step to finish 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. Once complete, you can click Create to have your report created.

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.

What is Accounting Reporting?

Take your reporting to the next level with accounting-specific reports. You’ll gain an even better understanding of the health of your business. This feature is currently still in a beta phase and some funtionalitiy is missing. More on accounting reporting coming soon!

What is the Profit and Loss Statement?

A summary of the revenues, costs, and expenses your company incurred during a specified period.


The following Chart of Accounts categories flow through to your P&L statement:

  • Income
  • Cost of Goods Sold
  • Expense
Please Note: Other Expenses & Non-Business Expenses do not flow to your P&L statement.

To run a P&L statement, click on Profit & Loss Statement in Reports. You can adjust the statement's specified period by clicking on the date dropdown to the top left of the statement.

You can toggle between a summary report, that shows you a basic summary of your P&L statement using the chart of account parent categories, or a detailed report that provides a detailed breakdown using both the chart of account parent categories and their child categories.

You can also export the report to a PDF file or CSV file, by clicking Export to the top right of the statement.

Please Note: At this point, you cannot save a P&L statement in Neat. This is a feature enhancement that is coming soon. In the meantime, you can export your report to a PDF file and import the PDF file back into Neat if you would like to store a copy in Neat.

What is the Balance Sheet?

A snapshot of your company's finances, including assets, liabilities, and shareholders' equity.

The following Chart of Accounts categories flow through to your balance sheet:

  • Assets
  • Liabilities
  • Equity

To run a report for your Balance Sheet, click on Balance Sheet in Reports. You can adjust the sheet's specified as of date by clicking on the date dropdown to the top left of the statement.

You can toggle between a summary report, that shows you a basic summary of your Balance Sheet using the chart of account parent categories, or a detailed report that provides a detailed breakdown using both the chart of account parent categories and their child categories.

You can also export the report to a PDF file or CSV file, by clicking Export to the top right of the statement.

What is the Cash Flow Statement?

The Cash Flow Statement provides data on how cash flows in and out of the business for a specific date range. Your Cash Flow activities are divided in the following sections:
  • Cash Flow from Operating Activities - a list of operating activities that resulted in cash received or paid by the business.
  • Cash Flow from Investing Activities - a list of investing activities that include the purchase or sale of fixed and/or long-term assets.
  • Cash Flow from Financing Activities - a list of financing activities that include proceeds received from a loan or fixed liability and payments made to a loan or fixed liability.
  • Total Cash Flow increase/(decrease) - the calculated amount of the increase or decrease in cash for the report period.

You can toggle between a summary or a detailed statement in the upper right.
  • The Summary will present the sum total for each of the Cash Flow activities.
  • The Detailed report presents a breakdown of the individual accounts and/or categories used to calculate the Cash Flow activity.

How did we do?


Powered by HelpDocs (opens in a new tab)