Docs / Insights
QuickBooks export
The QuickBooks export gives your accountant a period's invoicing and purchasing in one zip file. It holds the invoices, credit memos, payments, refunds, vendor bills and bill payments, as QuickBooks import files and as a journal, with the cost of the goods you sold. It works with QuickBooks Online and QuickBooks Desktop. Only administrators can export.
Exporting a period
Open QuickBooks export from the menu, under Insights.
1. Choose the Period: Last month, This month, Last quarter, This year or Last year, or set From and To yourself (up to a year). 2. Check the totals: invoices (with the cost of the goods on them, and of any returned to stock), credit memos, payments received (with any refunds) and vendor bills (with what was paid), with how many of each. The Files list shows how many rows each file has. 3. Select Download zip, and send the file to your accountant.
What's in the zip
- customers.csv and vendors.csv: every customer and vendor, with their billing address, phone and terms (and a customer's tax exemption). When two have the same name, their numbers tell them apart, since QuickBooks needs each name to be unique.
- products-services.csv: the products and services the invoices and credit memos use. Parts are listed by part number and units by their model (the assembly part number). Labor, shipping, sales tax and write-offs each have their own item. All of them are Non-inventory or Service items, so QuickBooks doesn't track stock a second time.
- invoices.csv: each invoice, one row per line, in QuickBooks Online's invoice import layout. Tax is a Sales Tax line on each invoice, so its total matches MQS Tracker's to the cent.
- credit-memos.csv: each credit note, one row per line, with the invoice it credits. Write-offs use the Bad Debt item.
- payments.csv, refunds.csv and credits-applied.csv: payments received against invoices, refunds of leftover credit, and credit notes applied to invoices.
- bills.csv: a vendor bill for what arrived on each purchase order, at the order's cost, dated the day it was received. A purchase order received over several days has a bill for each day: PO-000007, then PO-000007-2, and so on. Bills are due after the vendor's terms.
- bill-payments.csv: each purchase order paid in the period, from the payment you recorded on it: one row for each of its bills, with the method and reference.
- returns-to-stock.csv: goods customers returned that went back to stock or into rework, at their cost.
- voids.csv: invoices and credit notes from an earlier period that were voided in this one.
- journal.csv: every transaction above as a balanced journal entry, numbered after its document (such as INV-000123, or INV-000123-P1 for its first payment).
- journal.iif: the same journal for QuickBooks Desktop.
- README.txt: the steps for your accountant.
Detail or summary
Your accountant brings the period in one of these ways, only one, since using more than one counts everything twice:
- The detail: import the customers, vendors, products and services, invoices and bills into QuickBooks Online (Settings > Import data). Then enter the credit memos, payments and refunds, or import them with a tool such as SaasAnt or Transaction Pro, since QuickBooks Online doesn't import those itself. The detail doesn't move the cost of goods sold, or returned goods back into inventory; the journal does. Enter the bill payments with Pay bills.
- The summary in QuickBooks Online: import journal.csv as journal entries, or post it in any other ledger. Each receivable line names the customer, and each payable line the vendor.
- The summary in QuickBooks Desktop: back up the company file, then import journal.iif (File > Utilities > Import > IIF Files). It adds any of its accounts, customers and vendors that the company file doesn't have yet.
Journal accounts
The journal posts to the accounts in Journal accounts: receivable; labor, parts, units and shipping income; sales tax; where payments are deposited; where refunds are paid from; write-offs; inventory; cost of goods sold; payable; and where bills are paid from. QuickBooks Desktop's usual names differ a little (Accounts Receivable, Accounts Payable), so set them to match the company file. They start with QuickBooks Online's usual names. Change them to match your chart of accounts. Your names are remembered in this browser, and Use defaults puts QuickBooks' names back.
Inventory cost
The journal follows your goods through the books:
- A bill puts what was received into inventory, owed to the vendor.
- An invoice takes the cost of the parts and units on it out of inventory into cost of goods sold. The cost is each line's cost on its sales or service order. Labor has no goods cost.
- Voiding an invoice puts the cost back.
- Paying a purchase order clears what's owed to the vendor, from the account bills are paid from.
- When a return is approved, goods going back to stock or into rework come back into inventory at their cost, out of cost of goods sold. This only applies once their order has been invoiced, since that's when their cost went to cost of goods sold. Scrapped goods, and goods sent back to the vendor or the customer, stay in cost of goods sold.
How a period is counted
- An invoice counts on its invoice date, once it's issued. Drafts aren't exported.
- A credit note counts on its credit date, a payment on its payment date, a refund on its refund date, a bill on the day the goods were received, a bill payment on the day the purchase order was paid, and returned goods on the day the return was approved.
- A void counts on the day it was voided, reversing the original. If the invoice or credit note is in the same period as its void, neither is exported.
- Exporting a closed period again gives the same files, so you can send last month's export again after this month's voids. The exception is a purchase order whose receipts were undone (stepped back from Received): its bill leaves the period it was in.