Let’s face it…reporting is the lifeblood of every business. From routine financial reporting to satisfying compliance requests – you’re constantly faced with the need to extract and review your key accounting data. While necessary, this a task that can take up vast amounts of your time. Custom reports, on the other hand, are a way to make sure you get the data you need as quickly as possible.
The QuickBooks knowledgebase is filled with lots of questions about QuickBooks’ customized reports, so here’s an overview of what’s possible (and not possible) for custom reports in QuickBooks Online (referred to as QBO, moving forward, for the sake of brevity).
The different “flavors” of custom reports in QuickBooks Online
In the Reports section of your QuickBooks Online Dashboard, you’ll see that reporting is divided into three general categories:
- Standard: The library of default reports available in QuickBooks Online, which are pre-populated with your data and ready to go! This is where you’ll find the typical financial reports you’ll need to run.
- Custom Reports: A list of reports that you (or your team) have customized and saved.
- Management Reports: Groups of reports that have a cover page, table of contents, and space for opening commentary and endnotes. These are useful for any time that you need to dress up your reports for a specific audience.
Overall, there are four basic types of reports available:
- Transaction reports, which group transactional information in a variety of ways. This is the home of bread-and-butter reports like your P&L and Balance Sheet.
- List reports, where you’ll find information on your Chart of Accounts, Products/Services list, Customer and Supplier lists.
- Summary and Detail reports which, as their name implies, provide different rollups of the information contained within each report type.
It’s important to understand the basics of how reports are assembled in QBO, as they are the building blocks for any custom reporting you’d like to do.
What’s possible with custom reports in QuickBooks Online
While custom reports in QuickBooks Online do offer users a level of control, the truth is that these custom reports are essentially tweaks on the standard reports included out of the box.
In QuickBooks Online, a custom report allows you to:
- Personalize the report title and header information
- Set a reporting period, and formatting of numbers
- Add, remove, and re-order the columns associated with that report
- Apply report-level filters
The key piece to note here is that, in every case, you need to start with a standard report as the foundation of your custom report.
Questions are often posted to the help center around what’s possible with a custom report in QuickBooks Online.
I’ve distilled their feedback down to the following – a custom report in QuickBooks Online:
- Cannot combine data from different report types
- Must use the same look and feel of the report it’s built off of
- Can only leverage data available in QBO
In sum, custom reports in Quickbooks Online are a great starting point but inevitably you’ll find yourself in a scenario where you wish they could do a bit more. With that in mind, here are a few alternative approaches to consider.
Alternative #1: Spreadsheets
If you’ve found that you’ve hit a wall with the custom reports in QuickBooks Online, it may be time to consider extracting the data and manipulating it in Google Sheets or Excel.
As long as your exports include a unique identifier like a reference number or client ID, you’ll be able to combine data from different reports using the vlookup() formula.
Here’s an overview of the steps involved:
- Export the data you want to compile into a report (make sure you have a column you can match the data together with!)
- Import each data set as a unique worksheet in your spreadsheet.
- Decide on the final format. You’ll need to a) add columns to one of the reports to handle the matched data, or b) create a new spreadsheet with the relevant columns you’d like to combine.
- Use the vlookup() formula to extract data from one sheet and populate it into the final destination. Don’t forget to double-check your formulas…this is one of those formulas that can be a bit finicky when pasted across cells incorrectly! Here are some great videos outlining how to use vlookup in Excel and Google Sheets!
The beauty of this approach is that you can combine data however you want. Better yet, it gives you the ability to bring in external data sets and match them against your QBO data.
The downside is that this is quite manual and prone to human error due to the setup of the worksheets and formulas.
Alternative #2: The Method way
Reporting is a big deal to our customers here at Method, and I love the functionality our teams have built around the Report Editor.
One of our guiding principles here is to enable businesses to do more with QuickBooks, so we built our CRM reporting capabilities specifically to address the limitations of custom reports within QuickBooks Online.
Using Method’s reporting tools, you’ll be able to:
- Merge and combine all types of data into single reports (including both transaction and non-transaction data)
- Create beautiful reports using our drag-and-drop interface
- Leverage this powerful customization engine to tailor any document you can imagine, including QuickBooks invoices and estimates!
Because Method syncs all your QuickBooks data in real-time, you get live reporting without the limitations discussed above!
Wrap up: Custom reporting in QuickBooks Online
The built-in reporting capabilities in QuickBooks get any business off to a great start and do an amazing job of handling the “bread and butter” reports you’ll need regularly like your:
- Profit and loss statement
- Balance sheet
As you find yourself needing a bit more than the standard “custom” reporting capabilities provide, take a quick minute to celebrate – it’s a sign that your business is growing!
As discussed today, there are both short-term “stop-gap” solutions that can help, and a great long-term solution that will help you take your growth to the next level (in reporting and beyond!).
Learn how else you can extend the power of QuickBooks Online with Method in this free ebook.
Image credit: Free-photos via Pixabay