--- title: "QuickBooks Online Custom Reports: Build & Save | MCC" description: "Start from a standard report, filter, group and schedule it, then check it ties. Worked customer-concentration example." url: "https://mcc-solutionsnj.com/bookkeeping/guides/quickbooks-online-custom-reports" --- Bookkeeping guide · Updated October 12, 2026 # Building Custom Reports in QuickBooks Online The standard reports are a starting point. A good custom report answers one specific question, such as which customers owe the most or how this quarter's marketing compares to last year. You can save it and send it automatically. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** To build a custom report in QuickBooks Online, open the report nearest your question, click Customize and set the period, accounting method and grouping first. Choose cash or accrual deliberately, because totals will differ. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) · [Trial balance explained](/bookkeeping/guides/trial-balance-explained) · [Owner contribution or loan](/bookkeeping/guides/owner-equity-and-capital-contributions) **Free tools:** [Credit card fee calculator](/bookkeeping/credit-card-fee-calculator) · [How many sales do I need to break even?](/bookkeeping/break-even-calculator) [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## Start from the closest standard report Open the report that is nearest to your question. A profit and loss, a sales by customer summary or an aging report each has a Customize button. Changing the report period, the accounting method and the way the data is grouped comes first. Choose cash or accrual consciously, because totals will differ. ## Filter and group Within customize, use filters to limit by customer, vendor, class, location, account or amount. Group the data by month, quarter or customer. Add or remove columns, such as memo, class and the open balance. Keep the number of columns manageable so the report is readable on a phone or in a printout. ## Compare periods Turn on the option to compare to the previous period or the same period last year, with change columns for dollars and percentage. This highlights trends instead of leaving you to subtract numbers in your head. For a small business, a monthly profit and loss compared to the prior year is often more useful than a long list of accounts. ## Save, group and schedule Select Save customization to store your report with a name. Place it into a group, such as Owner monthly or Tax prep. Then set up an email schedule to send it on a certain day to yourself, a partner or your bookkeeper. Scheduled reports reflect the data at the time they run, so schedule them after your usual close day. ## Checking that the report is right A custom report can look polished and still be wrong. Compare the total of a filtered report against a standard one, and check whether a transaction without a class or customer has dropped out. Look at the date range and the basis once more. Use the drill-down to open any figure that seems odd, since clicking a number shows the transactions behind it. Keep a short list of the three to five reports you review every month, and use the same ones consistently. A report you actually read is worth more than a dozen you built and forgot. ## Reports worth building first Three useful starters are a monthly profit and loss compared with the same month last year, an open invoices report grouped by customer, and an expense report grouped by vendor for the year so far. Together they show profitability, collections and where the money goes. Add a fourth for tax season: a list of payments to contractors, by vendor, so 1099 preparation does not turn into a scramble. Name each report plainly so anyone on the team can find it. Give your accountant or lender a user login with limited rights, or export reports as PDF or spreadsheet. Include notes explaining unusual items. Date your exports and keep copies, because numbers may change after later edits. Consistent report packages each month make advisors faster and cheaper to work with. ## Worked example with numbers Start from the Profit and Loss by Customer report. Set the date range to the last twelve months, filter out inactive customers, group by customer and add a percent-of-income column. If the top customer shows 41% of income, that is a concentration risk worth a conversation. Save the report and schedule it to email monthly. Check it: add up the customer columns, and the total should equal the standard Profit and Loss total income for the same dates and basis. ## Mistakes that cost money Building from scratch when a standard report is close. Not tying to the standard report. Using the wrong accounting basis, cash versus accrual, which changes totals. Saving too many near-duplicate reports so no one knows which to use. ## Check your work Name each saved report for the question it answers, and review them yearly. ## Common questions **Can I export a custom report to a spreadsheet?** Yes. Use the export option, then add formulas or charts in your spreadsheet if needed. **Why does my report differ from my accountant's?** Often it is the accounting method, the date range, or a filter. Compare those settings first. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online) More guides - [Using the QuickBooks Online Audit Log](/bookkeeping/guides/quickbooks-online-audit-log) - [Undeposited Funds in QuickBooks Explained](/bookkeeping/guides/quickbooks-undeposited-funds-explained) - [Set Up Invoicing and Online Payments in QuickBooks](/bookkeeping/guides/quickbooks-online-invoicing-and-payment-setup) - [Receipt Capture and Attachments in QuickBooks Online](/bookkeeping/guides/quickbooks-online-receipt-capture-and-attachments) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Chart of Accounts and QuickBooks Import Pack Start your books with an account list built for your type of business, instead of the generic default, and compare it with the accounts you already have. [See what's inside ($24)](/toolkits/chart-of-accounts-quickbooks-import-pack)14-day full refund Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)