custom quickbooks reports
The Essential Step to Enabling Your Auto Import Tool
Your auto import tool currently requires this step. Your Profit and Loss statements and Balance Sheets must be setup to be automatically emailed out of QuickBooks which will allow Google Sheets to update with your current financial data.
How To Create The Reports
Start With Profit and Loss
Login to QuickBooks Online
Select Reports > Profit and Loss
Set the report period to “This Year”
Select “Months” under “Display columns by”
Under '“Show non-zero or active only”, select “All Rows/All Columns”
Choose your accounting method: “Cash or Accrual”
Click “Run report”
Click “Save customization”
In the Drop Down Menu, title the report as “Profit and Loss Auto” and click “Save”
Go “Back to report list”
Under the “Custom Reports” tab, find “Profit and Loss Auto” and under “Action” select “Edit”
Turn “Set email schedule” to ON
For SET RECURRENCE, set as follows for the plan you purchased:
All Plans: End “None”
Daily: Repeats “Daily” Every “1” day(s)
Weekly: Repeats “Weekly” Every “1” week(s) On “Sunday”
Monthly: Repeats “Monthly” Every “1” month(s) On Day “Last”
Note: if you purchased a Monthly plan and set the schedule as Daily, your Spreadsheet will still only process Monthly
In the “To:” field put info@wexfordepartners.com
Change the Subject to “Profit and Loss Report for <Your 3 Letter Code>”
Example: Profit and Loss Report for AAA
Select “Attach the report as an Excel file”
"Click “Save and close”
Step 13 - Select Based On Your Subscription
Steps 14 Through 17
repeat for Balance Sheet
Follow the steps above except in step 2 choose “Balance Sheet”
In step 4 choose “Active rows/active columns”
In step 8 save as “Balance Sheet Auto”
In step 10 edit the “Balance Sheet Auto” report you just created
In Step 14 change the subject to “Balance Sheet Report for <Your 3 Letter Code>”
Example: Balance Sheet Report for AAA
Attach as an excel file, save and close, and you’re all set! Good Job!
Balance Sheet Report Differences
UNCOMFORTABLE DOING THIS YOURSELF?
You can add us under your accountants and we’ll set it up for you.
Here’s the QuickBooks guide to add an accountant
Send the invite to andrew@wexfordepartners.com
Then send an email to andrew@wexfordepartners.com to let us know that you would like us to setup these reports for you
HOW DO I CHECK MY ACCOUNTING METHOD?
Check your Accounting Method by going to the Gear Icon > Account and Settings > Advanced > Accounting > Accounting method
Check above for a video tutorial.
How do I upload Previous Years Data?
Easy enough! Checkout our guide on upload previous years financial data.
NEED HELP?
Please contact us if you need help at info@wexfordepartners.com