Many of our customers have been requesting an updated feature that allows for a more detailed transaction report. We at G-Accon heard these concerns and are now excited to present the new and improved Detailed Transactions report! This new version displays all of the transactions that have occurred within a period of time (Date Range). This report is helpful if you need to review all of your transactions within a specific date range.

The Detailed Transactions report is designed to provide you with detailed information about customers, suppliers, expenses, and more. The report displays detailed information on customers and supplier paid accounts. Instead of balances and summary information, the report includes individual transactions. The Detailed Transaction report shows all of your accounts under the -Split- category.

How can I generate a Detailed Transactions report?

To get accounting report data from QuickBooks, you first need to be logged into QuickBooks. Then, you need to select Add-ons -> G-Accon for QuickBooks -> Get Accounting Reports -> Detailed Transactions.

Select the Detailed Transactions option from the drop down menu. G-Accon for QuickBooks gives you the ability to set up the Date Range for your data manually or you can refresh your data dynamically. The date range should not exceed 365 days.

Detailed Transactions Report

How can I choose filters?

With this feature, you are able to set up the Date Range (To and From) dynamically. The report data will be calculated based on the selected Date Range.

This image has an empty alt attribute; its file name is image-32.png
Dynamic Date Range

You also have the ability to set up the Date Range (To and From) statically. The report data will, again, be calculated based off of the selected Date Range.

This image has an empty alt attribute; its file name is image-31.png
Static Date Range

The following are required attributes for the Detailed Transactions report:

  1. Accounting Type(s)
  2. Transaction Type(s)
  3. Locations
  4. Classes
  5. Item(s)
  6. Term(s)
  7. Check Status
  8. AP Paid
  9. AR Paid
  10. Printed
Accounting Type(s)
Transaction Types
Check Status
AP Paid
AR Paid

QuickBooks provides Optional features that might be useful for your business.

Change Pull Settings allows you to perform the following operations:

  1. Create a new Google Sheet
  2. Display Report Title
  3. Display only account codes
  4. Keep Original Formatting
  5. Only data rows
  6. Only report summaries
  7. Retrieve headers
  8. Create a Data Table around pulled data
  9. Freeze Data Table Header
  10. Exclude Auto Refresh
  11. Remove empty dividing rows

You can also provide the start cell – for example, A1. You can also provide the name of the template in the Template Name field – for example, Template #1.

This image has an empty alt attribute; its file name is image-26.png
Change Pull Settings

How can I schedule an automatic refresh?

To schedule the auto refresh, you can create a workflow through the option “Create Workflow” and schedule both the auto refresh and notification processes. The automatic workflow allows users to create several workflows, include specific templates, set up different schedules for various workflows, and notify the customers, clients, and team members using different automatic notifications within the same spreadsheet. See the Automation process for further explanation.

To execute the process, click on the “Execute” button. The Detailed Transactions details will be populated in the Google Sheet.

Executed Detailed Transaction Report