How to build automated PBC (Prepared by Client) lists from QuickBooks data

Traditional PBC preparation requires extensive manual data extraction and formatting that’s prone to errors and version control issues. Creating comprehensive audit documentation requests shouldn’t be a manual, time-intensive process.

Here’s how to build automated PBC lists that generate comprehensive, current audit documentation requests directly from your QuickBooks data.

Create automated PBC lists using Coefficient

Coefficient builds automated PBC lists from QuickBooks data by importing core financial information and automatically generating standardized audit documentation requests. Your PBC lists stay current and comprehensive without manual data extraction.

How to make it work

Step 1. Import core financial data for standard PBC schedules.

Use Coefficient to import Trial Balance, Balance Sheet, and P&L data to automatically populate standard PBC schedules like account reconciliations, balance confirmations, and financial statement support. This creates the foundation for most audit documentation requests.

Step 2. Generate account-specific schedules automatically.

Import Account objects and filter by account types to automatically create PBC requests for specific categories. Cash accounts generate bank confirmation requests, AR creates aging schedule requests, and Fixed Assets produce depreciation schedule requirements.

Step 3. Create transaction-based PBC items.

Import Transaction Lists, Journal Entries, and related objects to automatically generate PBC requests for supporting documentation like invoices, contracts, and payment records above materiality thresholds. Filter by dollar amounts to focus on material items.

Step 4. Build customer and vendor schedules.

Import Customer and Vendor objects with balance information to automatically create PBC lists for receivable confirmations, payable schedules, and related party transactions. Include contact information for confirmation procedures.

Step 5. Automate inventory and asset schedules.

Import Item objects and fixed asset data to generate PBC requests for inventory counts, asset additions/disposals, and depreciation support. Include detailed asset information that auditors need for testing.

Step 6. Set up dynamic filtering for material balances.

Use Coefficient’s filtering capabilities to automatically focus PBC requests on material balances, unusual transactions, or specific audit risk areas based on predetermined criteria. This ensures audit attention focuses on significant items.

Step 7. Schedule regular updates throughout the audit period.

Configure automated refreshes to ensure PBC lists reflect current QuickBooks balances and transactions throughout the audit period. This eliminates outdated requests and ensures comprehensive coverage.

Step 8. Create standardized, reusable templates.

Build PBC templates that automatically populate with current QuickBooks data, ensuring consistency across audit periods and reducing preparation time. Templates can be customized for different audit requirements while maintaining automation.

Eliminate manual PBC preparation

Automated PBC lists ensure comprehensive, current, and properly formatted audit documentation requests while significantly reducing manual preparation effort. Start building your automated PBC lists today.