How to Customize QuickBooks Custom Reports?
- Last Updated on: January 9th, 2018
- Posted by: admin
- Category: QuickBooks Support
What are QuickBooks Custom Reports?
QuickBooks custom reports are a very important part of QB or we can say that these reports are a backbone of this accounting software. QuickBooks Desktop permits you to tailor the look and content of any company report that you need to generate.
You can customize the data, add or delete columns, add or remove details on the header or footer and even personalize the font and style of the report.
Available columns and filters differ for each report or group of reports because each draws details from the company report differently. Company report sources and targets are particularly significant when filtering company files.
Steps to customize QuickBooks online reports:
- First of all, go to QuickBooks Dashboard.
- After that, run a QuickBooks report.
- After that, go to the report window, click Customize Report.
- At last, go to the modify report window and then go to the tab you need to update and then select Ok when you have finished.
Read article: How to create and modify QuickBooks Scheduled Reports?
⇨ Display Tab
The Display tab determines the details that will be displayed on the company report. There are so many elements that you can modify, which vary depending on the report you run.
⇒ Report date range
You can choose the dates that the report will cover.
Choose the dates drop-down and then select the available date range or you can manually choose the date by choosing the calendar icon in the From and To fields. If you type a To date but leave the From date blank, you get data as of the To date.
⇒ Report basis
Choose either accrual or cash radio button to choose the report basis.
- A bookkeeping technique in which you regard income or expenses as occurring at the time you ship a product, render a service or receive a purchase.
- In accrual accounting, the time when you type a transaction and the time when you actually pay or receive cash may be two separate events.
- An accrual basis report shows income regardless of whether your buyers have paid your bills, and expenses regardless of whether you have paid all your bills.
- A cash related report express income only if you have received cash, and expenses only if you have paid cash.
- If you haven’t received an amount for the bill, an amount related report does not add the income.
You can see QuickBooks Report like Balance Sheet and QuickBooks Profit and Loss Report only have displays columns by drop-down where you can pick how you like the columns to appear across the top.
Open Invoices company Report and Unpaid Bills type Reports, on the other hand, provide a list that you can use for columns.
If you create custom fields and those fields were added to your templates and have details, they will also appear in the column list. To select a column, click the data. The ones you select have a verify mark.
A sort of drop-down permit you to select how the data will be shown. It decides how the report sorts within the subtotal. You can also arrange this in ascending or descending order.
Some Company reports also give the choice to Add subcolumns.
Choose available when you choose the Advanced option to vary depending on the report.
For reports like General QuickBooks Ledger, Custom Summary, Custom Transaction Detail, Vendor Balance Detail, QuickBooks sales like as Sales by Rep Detail, Sales by Customer, Sales by Item etc the choices are:
- Include: tells QuickBooks which of the accounts, names, item etc will be added to the company report.
- All: all account elements and list.
- In use: only the accounts and elements that have activity in the period selected.
- Open Balance or Aging: tells QuickBooks the effective date of the report and shows a transaction’s open the balance as of the effective date.
- Report Date: displays open balanced based on the date range selected for the report.
- Current: This displays open balances as of present day, regardless of the date time frame of the report.
For Balance sheet level, details of cash flows, QB profit and loss and vendor balance summary reports, you have display rows and display columns that tell QuickBooks which rows and columns to include in the report.
Read the article: How to set up QuickBooks preferences in QuickBooks Desktop?
Active: include all rows or columns that have activity in the selected date range, regardless of the balance.
All: all present rows and columns. Selecting all under advanced options overrides the filters.
Reporting Calendar: Selecting calendar year will show balance from January to December. The fiscal or income tax year depends on what you set in your firm details.
Non-Zero: This rows and columns include only a non-zero balance.
AR and AP aging summary reports provide you the option to select the Open Balance or Aging date.
⇨ Filters Tab:
Filter permit you to limit report details to selected criteria. This is especially important if you need to personalize the report for your needs or to isolate possible cause of an issue during troubleshooting.
Steps to filter a report:
- Go to the modify report window and then click filters
- And then click the filter list, choose the filter you like to use.
- After that, go to the filter detail information and then choose or type extra details that QB needs so the filter perform the task correctly.
- Go to the present filter choices column and then highlight a filter that you like to remove and choose to Remove Selected Filter.
- At last, click OK.
Note: QuickBooks shows a brief explanation of selected filter. If you want more information about the filter, then click the tell me more button.
⇨ Header or Footer tab
This button permits you to change the details that will show at the top and bottom part of the report.
The header details are the content that displays the report data. The footer is the content that appears below the report data. Footer content is only viewed in a print preview or on a printed copy of the report.
Verify or unclick the box for the details that you want to add or eliminate. Use the field provided to update the details.
To modify the alignment, click the alignment drop-down.
⇨ Fonts and Number tab
On this button, you can modify the style and appearance of a report. Areas of the report can be changed by modifying the font size, font, and font style.
Steps to change the font:
- Go to the change font for the column, choose the area you want to modify.
- After that, click Change Font
- Go to the Column labels window, change the font, font style, effect, and color for the font.
- Select Ok.
- At last, you will see changing font window, click Yes to apply the changes you made to all labels.
Titles should be 57 characters or less. You can include subtitle alphabets, but the date scale is no longer displayed. If a report has a customized title then click on Help in the menu bar and choose QuickBooks Help to see details about the base report from which it was developed.
Custom Summary and Custom Transaction Detail Reports
You can regulate the Custom Transaction Detail and Custom Summary files to create any firm report in QB with the help of the various type of combinations on the Display and Filters tab in the Modify Report window.
Just remember that this may also be subject to accounting and programming limitations as well as to your permissions in the data file.
- Both Reports have a default filter: Posting Status equal to Posting. Estimates, Sales orders, Pending Invoices and Purchase Orders don’t display until you modify this filter.
- The Custom Summary Report has a default filter of All Income or QuickBooks Expense Report Only these accounts are added until you modify the filter.
- In the QuickBooks Custom Report Summary, the rows and columns must be substantively different. For example, you can’t put buyers on the columns and vendors on the rows because both are part of the Name List.
For more information, dial our QuickBooks Phone Number +1-855-441-4417.