All our playbooks

How to create horizontal AR aging report with columns for each aging bucket in QuickBooks

Learn how to create horizontal AR aging reports with separate columns for each aging bucket using QuickBooks data and spreadsheet tools for better analysis.

How to create time-series charts of coverage ratios using HubSpot data

Create time-series charts of coverage ratios by automating historical HubSpot data collection and building trend visualizations.

How to create year-over-year comparison reports in QuickBooks Online

QuickBooks Online offers limited year-over-year comparison functionality. Here's how to create sophisticated YoY analyses with automated calculations and visual comparisons.

How to display 30-60-90-120 day aging buckets as separate columns in QuickBooks AR reports

Finance and collections teams can build a columnar AR aging report with customer names in rows and each aging bucket in its own column by importing QuickBooks AR data into Google Sheets or Excel using Coefficient's QuickBooks connector and applying bucket formulas on top. QuickBooks AR aging reports use fixed vertical layouts. There is no way to restructure the native report so that Current, 1-30, 31-60, 61-90 and over-90 balances appear as separate columns per customer row, which is the format most collections teams and CFOs actually want to work from.

How to export all open invoices for a specific customer from NetSuite to Excel

Learn how to export open invoices for specific customers from NetSuite to Excel with automated refresh capabilities and live data connections.

How to export multiple entities’ open invoices from NetSuite in bulk to Excel

Export open invoices for multiple NetSuite entities in bulk to Excel with automated refresh, flexible filtering, and unified formatting.

How to export invoice line items with product details to Excel weekly

Export NetSuite invoice line items with product details to Excel weekly using automated scheduling. Get granular SKU, quantity, and pricing data automatically.

How to export QuickBooks Online reports with formulas intact

QuickBooks Online exports reports as static values only, stripping formulas. Here's how to maintain live connections and preserve all formulas in your exports.

How to filter QuickBooks Online reports by custom fields

QuickBooks Online's report builder has significant limitations when filtering by custom fields. Here's how to access and filter by ALL custom fields effectively.

How to fix Salesforce dashboard filters not recognizing custom fields on Activity reports

Salesforce dashboard filters can't recognize custom fields from related objects on Activity reports. Here's a complete workaround solution.

How to fix NetSuite exporting Excel files as .XLS instead of .XLSX format

Fix NetSuite's .XLS export format issues with modern Excel. Learn how to get your NetSuite data in proper .XLSX format without manual conversion.

How to handle Google Sheets API rate limits when pulling data for real-time dashboards

Learn how to bypass Google Sheets API rate limits when building real-time QuickBooks dashboards. Eliminate 300 requests/minute bottlenecks with automated solutions.