)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
QuickBooks’ standard general ledger export lacks the flexibility to include related transaction details and supporting records in a single, organized format. Auditors need comprehensive documentation that connects GL entries to their supporting transactions.
Here’s how to export GL data with all the supporting documentation auditors require in a format they can easily navigate.
Export comprehensive GL data with supporting documentation using Coefficient
Coefficient pulls QuickBooks general ledger data along with comprehensive supporting documentation that auditors need. You can organize everything in a single workbook with linked references between GL entries and source documents.
How to make it work
Step 1. Import your GL data using the “From QuickBooks Report” method.
Pull the General Ledger report directly, or use “From Objects & Fields” to build a custom GL view with specific account selections and date ranges. This gives you the core GL data as your foundation.
Step 2. Add supporting transaction details from multiple objects.
Import related objects like Journal Entries, Invoices, Bills, and Payments into separate sheets within the same workbook. Coefficient lets you pull data from multiple QuickBooks objects simultaneously, creating a comprehensive audit package.
Step 3. Create linked documentation using Excel formulas.
Build formulas that link GL line items to their supporting transaction details using Transaction IDs or Reference Numbers as lookup keys. This creates the drill-down capabilities that auditors expect when reviewing GL activity.
Step 4. Set up automated documentation updates.
Configure scheduled refreshes to keep both GL balances and supporting documentation synchronized. This eliminates the common audit issue of mismatched supporting schedules that occur when data is pulled at different times.
Step 5. Filter by specific audit requirements.
Use Coefficient’s advanced filtering to focus on specific GL accounts, date ranges, or transaction types that auditors need to test. This reduces data volume while maintaining completeness of the supporting documentation.
Deliver audit-ready GL documentation
Comprehensive GL exports with supporting documentation give auditors structured, current data in formats they can easily navigate and analyze. Start building your audit-ready GL reports with Coefficient today.
