Export Financial Data

From Quickbooks (deprecated)

1. Log into QuickBooks Online
2. Go to Reports tab
3. Enter "Profit and Loss" in "Go to Report" search box
4. Click "Run"
5. Enter end date of last export in "From" and current day in "To"
6. Click "Run Report"
7. Make sure everything is categorized right. Sometimes similar fees will end up in two categories and can be consolidated into one by clicking into the category, then the transaction, editing the category, and saving.
8. When everything looks right click "Print" and save as PDF, then click "Excel" to download a .xls file.
9. Save files in /finance-and-administration/140121-140525/data/as-exported, with separate folders for /pdf and /xls
10. Repeat steps 2 - 9 for two additional reports titled "Profit and Loss Detail" and "Expenses by Vendor Summary." If the Vendor Summary seems to be missing transactions, you may have to go back through the Profit and Loss Detail in QuickBooks and manually make sure all imported transactions have been assigned a vendor.
11. Create a new Google Sheets document with the following 11 pages. The letters R, F, and C stand for Raw data, Formatted data, and Chart, respectively:

• R: Profit and Loss
• R: Profit and Loss Detail
• F: Expense by Category
• G: Expense by Category
• F: Visitors
• F: Salaries
• F: Subcontractors by Category
• C: Subcontractors by Category
• R: Expenses by Vendor Summary
• F: Expenses by Vendor Summary
• C: Expenses by Vendor Summary

12. Import .xls files downloaded from QuickBooks into the three "R" sheets.
13. For each "F" sheet, copy-and-paste relevant data from the associated R sheets and then strip formatting, relabel categories for understandability, and relayout as needed in order for Docs to generate a chart.