Step by step on Quickbooks and Excel

1-In the bank feed, on the Checking account, match the Tim Philip Masonry transaction for $666 to the PG&E Bill for $86.44, book the $579.56 difference to Office Expenses. 2- Reconcile the checking account as of today with ending balance $1,449.74. Clear all transactions except the $666 bill payment and the most recent two checks. Finalize the reconciliation. If youre not able to reconcile, Save for later.

3- Write off the $4 balance on the Freeman Sporting Goods | 55 Twin Lane invoice #1005 with a credit memo dated last day of prior month. Youll need to create a Bad Debt Product/Service and Account in the process. 4-Merge the Commissions & fees account into the Bank Charges account. 5-Run a monthly Profit and Loss report for this year-to-last-month that includes the Gross Profit % and excludes decimals on dollar amounts; shrink the report to show only parent accounts. 6-Drill down on the Total Expenses number for the year to show the expense transactions. 7-Export the transaction report to Excel and open it. Download it here (click File>Download, dont request edit access) if youre not able to in QuickBooks Online so you can complete the next step.

8- Create a pivot table of the exported expense data that shows total expense amount in descending order by vendor. 9-Download the Excel workbook here (click File>Download, dont request edit access) and complete the 5