Hi there, @Devon2.
We can import your invoices through an Excel file. Before diving in, let's make sure to turn on the Custom transaction numbers option and prepare your spreadsheet.
- Go to the Gear icon, then select Account and Settings.
- Choose the Sales Tab.
- On the Sales form content section, click the pencil icon.
- Put a checkmark in the box beside Custom transaction numbers.
- Click Save and then Done.
Once done, you can now upload your spreadsheet in QuickBooks Online. Here's how:
- Go to Settings ⚙ and select Import Data.
- Select Invoices.
It's important to make sure each line your spreadsheet’s column headings matches with QuickBooks fields. You can check out the correct mapping below to avoid errors.
- Fields with an asterisk (*) are required.
- Choose Not applicable for any fields not in your spreadsheet. If product or service isn’t added, QuickBooks populates with a generic item called "sales".
- Select the date format you used in your spreadsheet, like DD/MM/YYYY.
- Click Exclusive or Inclusive as your tax option.
- Hit Next.
After mapping, review the summary of your import. If everything looks good, select Start import.
Once done, you can now record invoice payments in QuickBooks Online after your customer pays their invoice.
If you have additional questions, feel free to click the Reply button. We're always here to help.