What Documents You Need for Shopify Catch-Up Bookkeeping (Complete Checklist)
- 2 days ago
- 11 min read
If you've decided to start catch-up bookkeeping or clean-up accounting work for your Shopify store, the single most impactful thing you can do, before any engagement begins, is gather your source documents. Document collection is one of the biggest time-killers in catch-up and clean-up bookkeeping engagements, often adding 2-4 weeks to timelines and creating frustration on both sides. Sellers who arrive with documents organized typically finish their catch-up bookkeeping 30-50% faster and pay 15-25% less because the work moves smoothly without constant interruptions.
This guide walks through exactly what documents you'll need, where to find them, and how to organize them so your bookkeeping engagement starts strong. Use it whether you're hiring a professional or attempting DIY clean-up bookkeeping yourself.
Why Document Collection Matters So Much
Most Shopify sellers underestimate how much of catch-up bookkeeping is actually document hunting. The mechanics of reconciliation are systematic and (with modern AI tools) fast. The real bottleneck is finding bank statements, supplier invoices, ad platform exports, and receipts for periods that may go back months or years.
A few realities most sellers don't expect:
Old bank statements aren't instantly available. Most banks take 1-2 weeks to fulfill historical statement requests for periods more than 12-24 months back.
Supplier invoices live in scattered emails. Few sellers have a centralized receipt system, so old invoices often require digging through email archives.
Ad platforms require admin access. Historical reports from Meta, Google, TikTok, and others can't be pulled without proper credentials.
3PL records may need account team support. Older fulfillment records sometimes require contacting your fulfillment partner directly.
Personal vs. business gets murky over time. The longer ago a transaction occurred, the harder it is to remember what was business vs. personal.
When you arrive at your catch-up engagement with all of this pre-gathered, the bookkeeper can start work immediately. When you don't, weeks of back-and-forth follow.
The Master Document Checklist
This is the complete list of documents typically needed for Shopify catch-up bookkeeping and clean-up accounting engagements. Not every store needs every item, your specific scope determines what applies.
Category 1: Banking and Payment Documents
These are the foundation of every catch-up engagement. Without them, reconciliation can't happen.
Bank Statements
Every business checking account
Every business savings account
For the entire catch-up period, month by month
PDF format preferred (CSV also works)
Statements should show opening balance, all transactions, and ending balance
How to get them: Log into online banking. Most banks let you download 12-24 months. For older periods, request from your bank directly, allow 1-2 weeks.
Credit Card Statements
Every business credit card
Personal cards if they were used for business expenses
For the entire catch-up period
PDF format preferred
How to get them: Log into the card issuer's portal. American Express, Chase, and most major issuers keep 24+ months online. For older periods, call the card company.
Payment Processor Reports
Shopify Payments payout history (download from Shopify Admin)
Stripe reports if used as secondary processor
PayPal transaction history
Square, Affirm, Klarna, Afterpay if applicable
How to get them: Shopify Admin → Finances → Payouts. For other processors, log into each platform's reporting section.
Wire Transfer Records
Any wire transfers in or out
Especially for international suppliers or customers
Category 2: Shopify-Specific Documents
These provide the e-commerce detail that generic bookkeepers miss.
Shopify Admin Access
Staff account with full reporting access (preferred)
Or collaborator access for your bookkeeper
Specifically needs: Orders, Reports, Finances, Settings → Taxes
How to set this up: Settings → Users and permissions → Add staff or collaborator.
Shopify Sales Reports
Monthly sales by period
Sales by payment method
Sales by country (for multi-currency)
Sales by channel (if multi-channel)
How to get them: Shopify Admin → Reports → Sales. Export to CSV for the catch-up period.
Shopify Refund Reports
All refunds during the catch-up period
Categorized by reason if possible
How to get them: Shopify Admin → Orders → filter by Refunded status, OR Reports → Sales → Refunds.
Shopify Payouts Detail
Each payout broken down into components (sales, refunds, fees, chargebacks)
Matched against bank deposits
How to get them: Shopify Admin → Finances → Payouts → Click into each for detail. AI sync tools like A2X or Link My Books pull this automatically.
Shopify Tax Reports
Sales tax collected by jurisdiction
Period-by-period
How to get them: Shopify Admin → Reports → Taxes, or your dedicated tax tool (TaxJar, Avalara).
Gift Card Reports
Gift cards sold (liability)
Gift cards redeemed (revenue recognition)
How to get them: Shopify Admin → Products → Gift cards → Reports.
Category 3: Sales Channel Documents (If Multi-Channel)
If you sell on platforms beyond Shopify, you'll need separate documentation for each:
Amazon
Settlement reports
Sales by SKU reports
FBA inventory reports
Refund and return reports
Amazon's 1099-K if revenue qualifies
How to get them: Amazon Seller Central → Reports → Payments → Date Range Reports.
Wholesale Platforms (Faire, Tundra, etc.)
Monthly payout reports
Order history
Returns and disputes
TikTok Shop / Instagram Shop / Other Marketplaces
Payout reports
Settlement statements
Tax forms (1099-K if applicable)
Direct Wholesale Customer Records
Invoices issued
Payments received
Outstanding A/R
Category 4: Cost of Goods Sold and Inventory
This is one of the most-skipped areas in DIY catch-up bookkeeping. Get these right and your gross margin will finally make sense.
Supplier Invoices
Every invoice from product suppliers
Manufacturing invoices if you produce your own products
For the entire catch-up period
How to get them: Search email for invoices. Many suppliers also have customer portals with downloadable invoice history.
Shipping/Logistics Costs (Inbound)
Shipping costs from suppliers to you
Customs and duties
Freight forwarder invoices
3PL Invoices
Monthly fulfillment invoices
Storage fees
Receiving fees
Returns processing fees
For warehousing partners like ShipBob, ShipMonk, Easyship, etc.
Inventory Records
Beginning inventory value (at catch-up start date)
Ending inventory value (at catch-up end date)
Physical count results if available
Inventory write-offs and damage records
Cost Per Unit Records
Landed cost calculations for each SKU
Includes product cost + inbound shipping + duties + handling
Category 5: Ad Spend and Marketing
Ad spend is one of the largest expense categories for most Shopify stores and one of the most miscategorized.
Meta (Facebook/Instagram) Ads
Campaign-level spend if needed for analysis
Receipts from billing email
How to get them: Ads Manager → Billing → Transaction history.
Google Ads
Campaign-level spend
How to get them: Google Ads → Tools → Billing → Documents.
TikTok Ads, Pinterest Ads, Snapchat Ads
Monthly billing for each platform
Settlement reports if managed through agencies
Affiliate and Influencer Payments
Records of payments to affiliates
1099-NEC records for affiliates paid $600+
Influencer payment receipts
Agency invoices if working through influencer management firms
Email/SMS Marketing
Klaviyo, Postscript, Attentive, Mailchimp subscription invoices
Per-message charges if applicable
Other Marketing
PR agency invoices
Content creator payments
Photography and creative production receipts
Category 6: Operating Expenses
Everything else that costs money to run the business.
Software Subscriptions
Shopify subscription
App subscriptions
Productivity software (Notion, Slack, etc.)
Accounting software (QuickBooks, Xero)
Sync tools (A2X, Link My Books)
Tax tools (TaxJar, Avalara)
Inventory tools (Inventory Planner, Cin7)
Receipt capture (Dext, Hubdoc)
Analytics tools (Lifetimely, Polar Analytics, Triple Whale)
How to get them: Most appear on credit card statements; cross-reference with email receipts.
Office and Workspace
Rent or coworking memberships
Utilities
Internet
Phone bills
Professional Services
Bookkeeping fees (your previous bookkeeper, if any)
CPA / tax preparer fees
Legal fees
Consulting fees
Web development and design
Shipping (Outbound)
USPS, UPS, FedEx, DHL bills
Shipping app fees (ShipStation, Shippo)
Shipping supplies
Travel and Meals
Business travel receipts
Trade show expenses
Business meal receipts
Category 7: Tax Documents
Critical for closing out the engagement and preparing for tax filing.
Prior Tax Returns
Federal returns for periods covered by catch-up
State returns
Sales tax returns by jurisdiction
Sales Tax Records
Returns filed (or not filed) by state
Payments made to state tax authorities
Notices received from any state
1099 Vendor Records
Contractors paid $600+ during the catch-up period
W-9s collected from each
Address information for 1099 filing
Payroll Records (If Applicable)
Payroll provider reports (Gusto, ADP, etc.)
941 quarterly returns
W-2 records
Owner reasonable compensation records (for S-corp)
Tax Notices
Any notices received from IRS or state agencies
Even if you don't think they're important, bookkeeper needs to see them
Category 8: Equity and Financing
Money flowing in/out that isn't revenue or expense.
Loan Documents
SBA loans
Lines of credit
Equipment financing
Business credit card credit limits
Investor Documents
Equity contributions
Investor distributions
Convertible note agreements
Owner Activity
Owner contributions to the business
Owner draws or distributions
Personal expense reimbursements through the business
Category 9: Documentation You Probably Forget
These often surface during catch-up engagements and slow things down:
Returned Merchandise Authorization (RMA) Records
Returns processed but not yet refunded
Inventory implications
Insurance Records
Business insurance premiums
Workers' comp if applicable
Product liability insurance
Legal Documents
LLC operating agreement
Corporate bylaws
Partnership agreements
Asset Purchases
Equipment purchases (laptops, cameras, etc.)
Vehicle purchases if business use
Software with multi-year licensing
Donations
Charitable contributions from the business
Sponsorships and community giving
How to Organize Documents Before You Start
How you organize documents matters almost as much as having them. Here's a structure that works for most Shopify catch-up bookkeeping engagements:
Create a Master Folder Structure
In Google Drive, Dropbox, or your preferred cloud storage:
Name Files Consistently
Use a format like: YYYY-MM_VendorName_DocumentType.pdf
Examples:
2025-03_ChaseBank_CheckingStatement.pdf
2025-06_MetaAds_Invoice.pdf
2025-09_ABCSupplier_Invoice_PO123.pdf
This makes documents findable and sortable.
Share With Read Access
When you hire a bookkeeper, share the entire master folder with read access. This is dramatically more efficient than email back-and-forth for individual documents.
Note What's Missing
Create a simple text file or spreadsheet listing documents you couldn't find. The bookkeeper can advise on alternatives or workarounds.
What Happens If Documents Are Missing
Don't panic, missing documents are normal, especially for older periods. Professional catch-up bookkeeping and clean-up accounting engagements handle this in several ways:
Reconstruction from secondary sources. Missing supplier invoices can sometimes be reconstructed from bank/credit card statements showing payments, supplier portal histories, or order confirmations.
Reasonable estimates. For periods where source documents are truly unavailable, reasonable estimates with documented methodology are CPA-acceptable. Your bookkeeper will document the assumptions.
Direct requests to vendors. Bookkeepers can often help request copies of missing invoices from suppliers, 3PLs, or platforms.
Bank statement reconstruction. Banks can usually provide statements going back 7+ years (sometimes with fees). For long catch-ups, this becomes critical.
Acceptance of incomplete data. Sometimes a transaction has to be recorded as "unknown vendor, $X, paid [date]" based on bank evidence alone. Not ideal, but workable.
For more on multi-year scenarios where documents are particularly hard to gather, see our years behind catch-up bookkeeping guide.
How AI Tools Reduce Document Needs
Modern AI bookkeeping tools have reduced the document burden for Shopify catch-up engagements compared to even a few years ago:
A2X and Link My Books pull Shopify historical data automatically, no manual export needed
Bank feed connections to QuickBooks or Xero eliminate the need for manually downloaded statements going forward
Dext and Hubdoc extract invoice data from emails automatically
TaxJar and Avalara reconstruct multi-state sales tax exposure from Shopify data
Like other AI accounting tools for Shopify sellers, these tools handle a meaningful portion of document gathering automatically. But human source documents (bank statements, supplier invoices, etc.) still need to be collected for periods before the tools were connected.
How Long Document Collection Takes
For a typical 12-month Shopify catch-up bookkeeping engagement:
Most documents on hand: 2-4 hours total time
Some documents to gather: 6-10 hours total time
Significant document hunting: 15-25 hours total time
Major reconstruction needed: Can extend engagement timeline by weeks
Sellers who delay document gathering until the engagement starts add 2-4 weeks to typical timelines. Sellers who arrive with documents ready often finish faster than initially quoted.
Documents You Don't Need to Gather
A few common misconceptions about what's required:
You don't need every receipt. For small expenses on credit cards (especially under $75), the statement entry itself is usually sufficient documentation. You don't need to find a coffee shop receipt from 8 months ago.
You don't need original paper copies. PDF scans, photos, and digital records are all acceptable. Don't waste time hunting for paper originals.
You don't need to organize transactions by category yourself. That's the bookkeeper's job. Don't pre-sort or pre-categorize transactions, let the bookkeeper apply consistent methodology.
You don't need every supplier invoice if you have payment records. Bank statements showing payments to suppliers are often sufficient. Original invoices help but aren't always required.
You don't need W-9s for foreign contractors. US 1099 requirements apply only to US-based contractors. Foreign contractors have different documentation requirements.
The Document-First Engagement Approach
The most successful Shopify catch-up bookkeeping engagements follow a "documents first" approach:
Week -2 (Before engagement starts):
Use this checklist to identify what you need
Request any older bank statements from your bank
Begin organizing documents in cloud folder structure
Identify what's missing and flag for follow-up
Week -1 (Right before engagement):
Complete document organization
Confirm system access (Shopify, accounting platform, ad platforms)
Final review of what's gathered vs. what's missing
Week 1 of engagement:
Hand off organized document folder
Discovery call with bookkeeper to review what's there and what's not
Bookkeeper begins immediate work, no waiting for documents
This approach typically saves 2-4 weeks on engagement timeline and prevents most cost overruns.
What to Do If You're Hiring a Bookkeeper
When you select a Shopify catch-up bookkeeping firm:
Ask for their document checklist upfront. A specialist firm will have one. If they don't, that's a warning sign about their process.
Compare it to this list. A comprehensive checklist should cover everything in this guide that applies to your situation.
Confirm secure sharing methods. Documents contain sensitive financial information. Confirm how the firm handles security (encrypted cloud storage, password protection, etc.).
Block calendar time for follow-up questions. Even with documents organized, the bookkeeper will have questions. Be available.
Don't pre-clean documents. Let the bookkeeper see what's there. Pre-cleaning often hides issues that need to be addressed.
For more on hiring decisions, see our guide to hiring a Shopify bookkeeper.
The Bottom Line
Document collection is the single biggest variable in how smoothly your Shopify catch-up bookkeeping or clean-up accounting engagement runs. Sellers who arrive prepared finish faster and pay less. Sellers who scramble during the engagement extend timelines and frustrate everyone involved.
Use this checklist before any engagement starts. Block specific time for gathering. Organize in a logical folder structure. The work to get organized upfront pays back many times over once the engagement is underway.
Ready to Get Started on Your Catch-Up?
Most Shopify sellers we work with have a similar reaction when they see our document checklist: relief that it's specific and manageable. Knowing exactly what to gather (and what you don't need) removes one of the biggest sources of pre-engagement anxiety.
At Catch Up Clean Up, we send every new client a customized document checklist based on their specific situation, not a generic list. We handle catch-up bookkeeping and clean-up accounting for Shopify stores using modern AI tools, with secure document handling and clear weekly communication throughout the engagement.
What you get:
A 30-minute scoping call to assess your specific situation
A customized document checklist based on your store's complexity
Secure cloud-based document handling
Flat-rate pricing with clear scope and timeline
Full catch-up bookkeeping using AI sync tools
CPA-ready financial deliverables
Optional ongoing monthly bookkeeping
Book a free consultation, and let's talk about what your specific catch-up engagement needs.
Frequently Asked Questions
What documents do I need for Shopify catch-up bookkeeping?
The core documents needed are: bank and credit card statements for the entire catch-up period, Shopify Admin access with full reporting permissions, supplier invoices, 3PL/fulfillment invoices, ad platform billing records (Meta, Google, TikTok), payroll records if applicable, prior tax returns, and 1099 records for contractors. The specific list depends on your store's complexity and channels.
How far back do I need to find bank statements for catch-up bookkeeping?
Bank statements are needed for the entire catch-up period. Most banks keep 12-24 months of statements online; older periods typically require contacting the bank directly, which can take 1-2 weeks to fulfill. For multi-year catch-ups, request older statements as early as possible, they're often the longest lead-time item.
What if I don't have all the supplier invoices for my catch-up bookkeeping?
Missing supplier invoices are common and manageable. Bookkeepers can often reconstruct missing data from bank/credit card statements showing payments, supplier customer portals, or by requesting copies directly from vendors. For truly unavailable documents, reasonable estimates with documented methodology are CPA-acceptable.
Should I organize my documents before hiring a bookkeeper?
Yes, strongly recommended. Organized documents typically reduce engagement timelines by 30-50% and reduce cost by 15-25%. Create a master cloud folder with subfolders for each document category (banking, credit cards, Shopify, suppliers, ad platforms, etc.), name files consistently, and share with read access to your bookkeeper.
How do I give my bookkeeper access to Shopify and QuickBooks?
For Shopify: Settings → Users and permissions → Add staff or collaborator. Collaborator access is more secure than staff access for external bookkeepers. For QuickBooks Online: Settings → Manage users → Add user → choose "Accountant" role. Both platforms support remote access without sharing your personal login.
Do I need to find receipts for every business expense?
No. For small expenses on credit cards (typically under $75), the statement entry is usually sufficient documentation. Focus your document gathering on larger transactions, recurring vendors, and anything where bank/card statements alone don't tell the full story (like supplier invoices that need to be matched to inventory).
What's the difference between documents needed for catch-up bookkeeping vs. clean-up accounting?
The document needs are similar, but the focus differs. Catch-up bookkeeping needs documents to fill gaps in missing data (full bank statements, all invoices for unentered periods). Clean-up accounting needs documents to verify what's already entered (statement copies to cross-check existing transactions, original invoices to confirm categorization). Most engagements need both.
Comments