Quickbooks Online Advanced - Advanced Reporting
Custom Open Balance Reports
From Chart of Accounts Select Down arrow next to account Run Report Change the Report dates to all dates Filter by Cleared Select Uncleared Run report
What are the customization Options?
General Aging Rows/Columns Filter Header/footer
How do you add scheduled Reports? (Only Customized Reports Can be Scheduled)
Go to the Report Center Select Report Change the Report Period Add other Report Period as a Comparison if wanted Run Report Select Save Customization Name Customized Report Save
Report Date Aging Method
IF the invoice was due on that date it doesn't matter if it was paid after that date it will show
3 Main Expense and Purchase Reports
Purchases by Vendor Detail Expenses by Vendor Summary Transaction List by Vendor Comparing these reports will not necessarily give the same totals
Credit Cards and Cash Basis
Quickbooks treats credit card activity as if they were paid by cash It does not reverse the entries like the A/P account. The Balance sheet will show a balance in the liability account. Expenses paid are included in cash basis P & L
How do you set up Management Reports
Reports Center Management Reports Chose the Template Copy Template
Best Sellers and Profitabilty by Product Report
Run Sales by Product/Service Summary Report Sort it by Total to show highest Sales Amount
Transaction Count Report
Run Transaction list by Date Report (My Accountant Section) Selection Date Range Run Export to Excel to get count
Budget reports
Two Different Types of Reports Budget Overview report Budgets v. actual Report
IF a payment is made to a bill before the date of the bill it is applied to the payment will be shown as
Unapplied Cash Bill Payment Expense
IF a payment is made to an Invoice before the invoice is dated it is applied to
Unapplied Cash Payment Income
Breakdown of Contributions Report for Non Profit
1. Reports Center 2. For My Accountant 3. Transaction Detail by Account Report 4. Customize 5. Set Report Period 6. Select accounting method as Cash 7. open Row/Columns 8. Group by drop down and select donor 9. Select Change Columns and Remove any unwanted
How to create register balance Report (It helps to determine available funds)
1. Run Account List Report (For My Accountant Section) 2. Customize it to report only on accounts of type all bank accounts 3. Change the columns to the ones wanted 4. such as account and balance 5. This Report can be saved and scheduled
Open Sales Order Report
1. Run Estimates by Customer Report 2. Customize is it to only filter to only include accepted 3. Change the Header to Read Open Sales Orders 4. Save the Customized Report
Cash Basis Balance Sheet
A/R & A/P should always be Zero Open Bills and Invoices will not be reflected in Target Acct Balance
What is the 1st set of options in the filter list
All Not specified or transactions by name specified
Which Filters do not have drop down fields?
Amount Ship Via Memo Custom Fields Num
What are the predefined Management Reports only Accountants see?
Basic Company Financials Expanded Company Financials
What are the three predefined Management Reports Accountants & Clients see ?
Company Overview Sales Performance Expense Performance
Options for Aging Methods
Current Aging Method Report Date Aging Method
Report Filters
Displayed at the Top of the Report To remove a filter select X
What are Quickbooks Management Reports
Editable Templates allow you as a trusted to Packaged set of reports for the client in pdf format All of the information in Quickbooks can be packaged up into a professionally designed management Report
How does QBO create cash basis reports
It omits A/R and A/P Transactions
Cash Basis Profit & Loss
Only Income Received and Expenses paid appear does not include unpaid bills or invoices Uses Paid Status to determine whether the transaction should be included in the cash basis report
How do you create schedule for Scheduled Reports
Select Custom Reports Tab in the action column select edit Set the email recurrence Enter email information Select Excel if you do not want it sent as a pdf save
How to create a budget
Select Gear Icon Chose Budgeting Select Add Budget Name the Budget From the Fiscal year drop down select the year Interval drop down chose monthly, quarterly or yearly
Headers & footers allow you to
Show Logo Change Company Name Change Report title add date and time report was prepared Show or hide the report basis Change Header or Footer Alignment
Budget Overview Report
Shows a summary of budgetes amounts for a specific budgey
Quickbooks Online Reports
Summary Reports Transaction Detail Reports List Reports Aging Reports Special Reports
Budget v. Actually Report
Summary of budgeted amounts v. Actual amounts and their variances and variance percentages
Unapplied cash payment income
When a customer payment is recorded but not applied to an invoice
What is a great Benefit of QBO Reports
You can run both cash and accrual reports
Gear Icon on reports
add or remove columns change the order in which columns are displayed toggle between regular and compact
Client Does their own bookkeeping - schedule
ask my accountant
Budgets in Quickbooks online
based on fiscal year set up in Accounts & Settings You can only set up Budgets for P&L Accounts No Budget for Balance Sheet You can only create budgets 1 year at a time You create and management mutliple budgets
new budget
editing budget
Unapplied Cash Bill payment Expense
if an expense or check transaction is entered and posted to A/P with no bill associated with it This account can't be adjusted
Current Aging Method
not currently due
what can you not do in header or footers?
see photo
which fields do not have drop downs
see photo
Customization using the report Header Options
you can change the reporting period and accounting method