QuickBooks Online CSV Journal Entry Import Moved to Spreadsheet Sync
QuickBooks Online users report the journal entry import now opens Spreadsheet Sync instead of the usual CSV upload. Here is what changed and what to do.
QuickBooks Online users who import journal entries from a CSV file are running into a surprise. The familiar Import Data path for journal entries now opens Spreadsheet Sync rather than a simple upload screen. For shops that post payroll summaries this way, a workflow built over years just gained a step. Here is what we know, and what you can do about it.
What changed?
Reader reports describe a consistent picture. Choosing the Settings gear, then Import Data, then Journal entries lands on Spreadsheet Sync instead of a file picker. Spreadsheet Sync is a tool from the vendor that connects a spreadsheet to QuickBooks Online and moves data between the two. We have not seen a dated announcement in the material we reviewed, so treat rollout details as still emerging. What is clear is the direction: for affected accounts, the direct upload is out and the spreadsheet link is in. If your menu still shows a file picker, the change has not reached you yet.
Who is affected?
Any accountant or business that brings outside data in as journal entries feels this. Payroll is the loudest case, because many payroll services hand you a CSV of debits and credits each period. Bookkeepers importing adjusting entries or year-end corrections report the same redirect. Your existing files are not the problem. The data is fine; the door you used to walk it through has moved.
How does Spreadsheet Sync handle the import?
The tool trades a one-time upload for a one-time setup. You authorize it, connect a Google Sheet or an Excel workbook, and pick journal entry as the data type. You then map your columns once, and that mapping becomes the template you reuse. Each payroll run, you paste the new figures into the sheet and sync. Nothing is retyped, so the wheel is not rebuilt every time. The cost sits up front: setup, permissions, and the slow loading several readers have noted.
Can you keep your old CSV file?
Yes, as data if not as an upload. Opening the CSV and copying its rows into the connected spreadsheet preserves the columns you already have. Third-party import apps listed in the vendor’s marketplace can also bring journal entries in. Small batches can still be typed by hand. If the source is a payroll service, ask whether it can post entries to QuickBooks Online directly; some can.
Before your next payroll import
Run the first sync with a small test batch, not a full payroll period. Then pull the journal report for that date range and compare totals against your payroll register. Debits must equal credits, and net pay should match to the cent. Once the template proves out, the recurring work drops back to paste and sync. Do that dry run before the next real deadline, not during it.