How to Move Off Spreadsheets and Start Getting Paid Online with QuickBooks Payments
You sent an invoice from a spreadsheet, the customer paid through another app, and now you are switching between your bank account and invoice tracker just to confirm the payment.
Before you finish updating the file, another invoice needs your attention, and you are back in the spreadsheet trying to work out what is still outstanding.
That process can feel manageable at first, but as more customers come in, the time spent updating rows and matching payments starts to add up. One missed entry can even leave you chasing a payment that has already arrived.
This guide helps you replace that routine with a clearer process in QuickBooks Payments.
We’ll walk you through preparing your records and setting up online payments so you can send payable invoices and track them in one place.
The Benefits of Moving From Spreadsheets to QuickBooks Payments
Once you move your invoicing into QuickBooks Payments, it becomes easier for customers to pay you.
Their available payment options appear on the invoice, so you no longer have to send separate instructions. It sounds like a small change, but it removes an extra step between sending the invoice and getting paid.
Your records become more useful too. You can review incoming payments without piecing together information from several places, and you have cleaner information when it is time to run a report or speak with your accountant.
Before you get there, let’s look at what needs to move into QuickBooks Payments and how to prepare it.
What to Know Before You Switch From Spreadsheets to QuickBooks Payments
Before you start importing anything, it helps to sort out three things. Doing this now can save you from stopping midway to fix records or look for missing account details.
Decide What You Actually Need to Bring Over
You do not have to transfer every invoice you have ever sent.
Start with active customers and unpaid invoices, then choose a date when you will begin creating all new invoices in QuickBooks Payments.
Keep an untouched backup of your original spreadsheet. Older paid invoices can stay there unless you need them in QuickBooks Payments for reporting or recordkeeping.
Gather the Setup Requirements
To set up QuickBooks Payments and receive online payments, you will need:
- A QuickBooks Payments account on a plan that supports the features you need
- Your business and owner information for the QuickBooks Payments application
- A bank account where your customer payments will be deposited
QuickBooks Payments requires a separate approval. Intuit normally emails its decision within a few business days, so applying early can prevent it from holding up the rest of your setup.
Clean and Format Your Spreadsheet Data
Review your customer and invoice records before uploading them. Remove duplicate entries, blank rows, formulas, and outdated information that could cause problems during the import.
Customer lists can be imported from CSV, Excel, or Google Sheets, while invoice imports require CSV. You should also make sure customer names are consistent and add any products or services you plan to use on your invoices.
Once these pieces are ready, you can begin the setup and import process with fewer interruptions.
How to Move Off Spreadsheets and Start Getting Paid Online in QuickBooks Payments
Here’s how you can move from spreadsheets to QuickBooks Payments and begin accepting online payments.
1. Sign Up for QuickBooks Online and Apply for QuickBooks Payments
Follow these steps to apply for QuickBooks Payments:
- Create your QuickBooks Online account.
- Go to Settings ⚙ → Account and settings → Payments.
- Select Learn more, then Set up Payments.
- Enter your business and owner information.
- Choose the bank account where customer payments will be deposited.
QuickBooks Payments normally emails its decision within a few business days, although Intuit may request additional information.
Start this step first and prepare your spreadsheet data while waiting for approval.
2. Clean and Back Up Your Spreadsheet Data
Save an untouched copy of your current spreadsheet, choose a clear migration date, and separate your active customers and unpaid invoices from closed historical records.
Correct duplicate names, blank rows, formulas, and outdated information before importing anything.
3. Import Your Customer List
Go to Settings ⚙ → Import Data → Customers and upload your customer list. QuickBooks Payments supports CSV, Excel, and Google Sheets files for customer imports.
Each file is limited to 1,000 rows or 2MB. Customer names must be unique, and the initial import supports one email address per customer.
4. Import or Recreate Your Open Invoices
After importing your customers and setting up the relevant products or services, go to Settings ⚙ → Import Data → Invoices. Invoice imports require a CSV file and support up to 100 invoices or 1,000 rows per upload.
Each line item needs an invoice number, customer, invoice date, due date, and item amount. Negative amounts, including discounts and credit memos, cannot be imported and must be added afterward.
The current invoice-import documentation also states that this method cannot be used after sales tax has been configured.
Availability may vary by plan and account. If Invoices does not appear under Import Data, recreate your current open invoices manually or contact QuickBooks Payments support to confirm your available import options.
5. Configure Deposits and Online Payment Options
Once QuickBooks Payments is approved, complete these settings:
- Under Settings ⚙ → Account and settings → Payments, select the accounts used to record deposits and processing fees.
- Under Settings ⚙ → Account and settings → Sales → Invoice payments, select the payment methods customers can use.
- Under Settings ⚙ → Account and settings → Sales → Online delivery, make sure Online Invoice is selected.
Customers may be able to pay by card, ACH bank transfer, Apple Pay, PayPal, or Venmo, depending on the payment options available to the account.
6. Review and Send Your First Payable Invoice
Open an imported invoice or create a new one for a current customer.
Confirm the customer, amount, due date, and payment options. On the invoice, open Manage → Payment options and turn on the methods you want to offer. Then select Review and send.
The customer will receive an online invoice with a payment link instead of having to pay separately from a PDF.
7. Confirm the payment was recorded and track the deposit
When the customer pays through the invoice, QuickBooks Payments should create a received-payment transaction and apply it to the corresponding invoice.
Check the invoice status and QuickBooks Payments payouts to confirm that the payment was processed and track when it is sent to your bank.
Automatic matching, where available, reduces manual entry, but users should still review transactions and reconcile their bank account regularly.
Signs Your Move From Spreadsheets to QuickBooks Payments Was Successful
After completing the steps above, first check that your customer records and open invoices were imported correctly. Then send an invoice and confirm that the customer receives an online payment link.
Once they pay, QuickBooks Payments should record the transaction, mark the invoice as paid, and show the payment under QuickBooks Payments payouts so you can track its deposit.
Keep in mind that the invoice may show as paid before the money reaches your bank.
Your first deposit may take up to five business days. After the initial setup period, accounts with next-day deposits generally receive payments processed before 3 p.m.
Pacific Time by the next business day, while later payments may take up to two business days. That cutoff is 4 p.m. Mountain, 5 p.m. Central, and 6 p.m. Eastern.
Common Mistakes and Pro Tips
Most problems after switching happen when your old payment process overlaps with your new QuickBooks Payments records. Here’s what to watch for once you begin sending live invoices.
Continuing to Use Old Payment Methods Without a Cutover Plan
Tell customers which invoices should be paid through QuickBooks Payments and how you will handle checks or standalone Venmo payments after the switch.
If a customer pays outside QuickBooks Payments, record the payment against the correct invoice so it does not remain incorrectly marked as overdue.
Sending Every Imported Invoice Before Testing the Workflow
Review your imported invoices before sending them to customers.
Start with one invoice and confirm that its balance, due date, payment options, and payment link work correctly before using the new process with everyone.
Reimporting an Entire File After a Partial Failure
Some customers or invoices may import successfully even when other rows fail.
Review the import results and correct only the failed records, since uploading the entire file again can create duplicates instead of replacing the original entries.
Adding a Downloaded Deposit Instead of Matching It
QuickBooks Payments creates a payment record when an invoice is paid.
When the deposit later appears in your bank feed, match it to the existing record instead of adding it as new income, which could count the same payment twice.
Expecting Every Deposit to Equal One Invoice
QuickBooks Payments may combine multiple customer payments into one deposit and display the related processing fees separately. Check the deposit details under QuickBooks Payments payouts before treating a difference between the invoice and deposit amounts as an error.
Conclusion
Moving away from spreadsheets can make invoicing and payment tracking much easier, and I hope this guide gives you a clear place to start.
When you are ready, see how they can help you manage your business, compare their plans, or learn how their online payments work.
Good luck with the switch and whatever comes next for your business.
FAQs About Moving Off Spreadsheets and Getting Paid Online in QuickBooks Payments
How long does it take to switch from a spreadsheet to QuickBooks Payments?
The hands-on setup may take a few hours, but QuickBooks Payments approval can extend the process. QuickBooks Payments normally emails its decision within a few business days.
Can I import my existing spreadsheet directly?
Yes, although the accepted format depends on what you import. Customer lists support CSV, Excel, or Google Sheets, while invoice imports require CSV and have separate upload limits.
Which payment methods can my customers use?
Customers can pay by card, ACH bank transfer, Apple Pay, PayPal, or Venmo, depending on the options available for your account.
What does it cost to accept online payments?
QuickBooks Payments charges processing fees in addition to your QuickBooks Online subscription. Current US rates are 2.99% for invoiced card and digital-wallet payments, 1% for ACH, and 3.5% for keyed cards, but check the rates page for updates.
Do I need any accounting background to do this?
You do not need to be an accountant to import customers or send payable invoices. However, you should still review your setup and reconcile your accounts regularly.
