The Way You Need Them?
Custom Reports For Quickbooks Exactly The Way You Want Them.
8 Situations for Custom Reporting - Which One Do You Have?
1. Eliminate Manual Processes
a. Exporting to Excel, and then manually cobbling reports together, and formatting, week after week, month after month, is a tremendous waste of time with too much opportunity for human error. Find out who in your organization is exporting from QuickBooks to Excel – and why? Some folks just get used to the task and don’t think about how it could be done more effectively.
2. No Access to QuickBooks
a. Who needs the data but doesn’t – or shouldn’t – have access to QuickBooks? If the only reason for having as many licenses as you do is to give people access to the Reports in QB, you could free up some licenses and save some money with a custom report, get useful information into the hands of those who really need it, and further protect your QuickBooks data.
3. Unusual Format Required
a. Frequently a “flat file” or CSV format is imposed by governments, banks, investors, and auditors for uploading into different software applications. No need to do this manually! And sometimes, your manual report process may be compensating for a poor system set up, such as a Chart of Accounts or Items. You might even need customized account groupings for certain reports.
4. Specific Look & Feel Required
a. Sometimes a unique ratio or other calculation is needed. Perhaps the font, color, or placement of objects on the page is not editable in QuickBooks. You might even need dynamic images – such as photos of items or different logos. Another common requirement is for conditional features (If X then do Y). Custom reports do this beautifully!
5. Need to Include External Data
a. Related data could be important – but you can’t link that to in-app reports. It could be as simple as needing a description for the Class – but there is no place to put that data in QuickBooks so it needs to come from another data source. We often use Excel for these kinds of situations – cheap and cheerful!
6. Report Distribution
a. Need to send the report(s) out to more than a couple of people on a regular basis? We love using PDF-Explode for doing that – major time saver, and for some, a game-changer. This has to be done using Crystal Reports, so we can easily add the details that PDF-Explode requires.
7. Remove Bottlenecks
a. Are you (or is anyone else) interrupting the work of someone in Finance to request a report on a recurring basis? Stop the madness and enable self-serve through a Custom Report using Crystal Reports & QQube!
8. QuickBooks Limitations
a. Oh my – there are so many. Here are the general ones that apply to both Desktop and Online…
b. When it says “Customize Report”, options are still limited
i. Can’t include combinations of periods (Month, Quarter, and Year)
ii. Only have the fields offered
iii. No custom fields!
c. Can’t easily consolidate
i. Multiple entities
ii. Individual or consolidated Classes
d. Can’t do non-standard reporting periods
i. 13×4 week periods, budgets
e. Here are the ones specific to QB Desktop…
f. Commissions – only one sales rep and commission rate per customer – and no actual report to do the calculation
i. Can’t view inventory quantities for an item – with sales history
ii. Can’t easily extrapolate quantities of assembly parts needed
h. And here are the ones for QuickBooks Online…
i. Can’t easily get at the data
j. If you do – it’s in Excel format
k. The built in Dashboards are wrong if your account isn’t reconciled because it double counts the unreconciled transactions!