This guide outlines the professional workflow for synchronizing TireBase data with QuickBooks (QB). You can choose between a Summary Journal Entry (fastest for monthly reporting) or a Bulk Data Import (best for detailed transaction history).
This method summarizes a month of activity into a few entries to keep your QuickBooks ledger clean while ensuring your Profit & Loss and Balance Sheet are accurate.
Run these reports in TireBase at the end of each month:
Transactions Report (Invoices & POs.csv): Provides total revenue, sales tax, and the Cost of Goods Sold (COGS).
Transactions Report (Payments & Paidouts.csv): Shows actual cash, card, and digital payments collected.
Inventory Stock Status: Provides the target value for your ending inventory asset.
Vendor Aging Trial Balance: Confirms your outstanding Accounts Payable (what you owe suppliers).
Use these tables as templates for your monthly entries. Ensure total Debits equal total Credits.
This entry records your income and simultaneously moves the value of sold tires/parts out of your inventory asset account.
| Account Name | Debit (+) | Credit (-) | Source Report |
| Accounts Receivable | $X,XXX.XX | Invoices CSV: Total column | |
| Cost of Goods Sold | $X,XXX.XX | Invoices CSV: Cost column | |
| Sales Revenue | $X,XXX.XX | Invoices CSV: Subtotal column | |
| Inventory Asset | $X,XXX.XX | Invoices CSV: Cost column | |
| Sales Tax Payable | $X,XXX.XX | Invoices CSV: Tax column |
This entry moves the actual money you collected into your bank account and reduces the balance in Accounts Receivable.
| Account Name | Debit (+) | Credit (-) | Source Report |
| Bank / Undeposited Funds | $X,XXX.XX | Payments CSV: Total Amount | |
| Accounts Receivable | $X,XXX.XX | Payments CSV: Amount applied to AR |
If you added new tires or parts to TireBase during the month, you must increase your inventory asset value in QuickBooks.
| Account Name | Debit (+) | Credit (-) | Source Report |
| Inventory Asset | $X,XXX.XX | Vendor Aging: Total of new bills | |
| Accounts Payable | $X,XXX.XX | Vendor Aging: Total owed to suppliers |
Use this method if you need individual invoice and customer details inside QuickBooks Online (QBO).
Download: Export the Transactions Report from TireBase as a CSV file.
Filter: Open the file in Excel or Google Sheets. Use Data > Filter on the "Transaction Type" column.
Segment: Create separate CSV files for "Invoices," "Customers," and "Products." QBO cannot process one giant mixed file.
Navigate: Click the Settings (Gear icon ⚙️) and select Import Data.
Select Category: Choose the tile that matches your filtered file (e.g., Invoices).
Map Fields: Match the QuickBooks fields to your TireBase columns (e.g., Match "Amount" to "Total Price").
Review: Preview the data for date format ($MM/DD/YYYY$) and decimal accuracy, then click Import.
To ensure your records are perfect, compare your QuickBooks Balance Sheet to your TireBase reports at month-end.
Inventory: The "Inventory Asset" balance in QB should match your TireBase Stock Status report.
A/R: The "Accounts Receivable" balance in QB should match your TireBase A/R Aging report.
A/P: The "Accounts Payable" balance in QB should match your TireBase Vendor Aging report.
Initial Setup Note: If this is your first time, perform an "Opening Balance" entry to record your current inventory value as a Debit to Inventory Asset and a Credit to Opening Balance Equity. This establishes your starting point before you begin monthly recording.
We also offer an API option that can be configured with Zappier, Zoho Flow, Make, N8n or any automation tool that supports https requests ro api reuqests.