Accurate invoice management is essential for maintaining up-to-date financial records in QuickBooks. Whether you need to correct mistakes, cancel transactions, or keep your records tidy, understanding how to edit, delete, and void invoices is crucial. This guide explains each process, their differences, and provides steps for various QuickBooks scenarios.
Editing an invoice is the best option when you need to correct errors such as incorrect rates, quantities, customer details, or dates.
QuickBooks Online
Access the Invoice:
Go to Sales and then select Invoices.
Find and click on the invoice you need to edit to open it.
Make Changes:
Click Edit in the top right corner of the invoice.
Update the necessary fields, such as the invoice date, customer details, items, quantities, rates, or amounts.
Save Changes:
After making your edits, click Save and close or Save to update the invoice.
QuickBooks Desktop
Locate the Invoice:
Go to the Customer Center from the Customers menu.
Find and open the invoice you wish to edit.
Edit and Save:
Make the required changes directly within the invoice.
Click Save & Close to save your edits.
Deleting an invoice should be done with caution as it completely removes the invoice from your primary records.
QuickBooks Online
Access Invoices:
Navigate to Sales > Invoices and locate the invoice.
Delete the Invoice:
Option 1: From within the Invoice:
Open the invoice.
Click More at the bottom of the invoice.
Select Delete.
Confirm the deletion by clicking Yes.
Option 2: From the Invoice List:
Find the invoice in the list.
In the Action column for that invoice, click the dropdown arrow.
Select Delete.
Confirm the deletion by clicking Yes.
Important Consideration: Deleting an invoice permanently removes it from most reports and affects customer balances. While deleted invoices are tracked in the Audit Log, they are not easily recoverable.
QuickBooks Desktop
Open the Invoice:
Go to the Customers menu and select Customer Center.
Locate and open the invoice you intend to delete.
Delete the Invoice:
With the invoice open, go to the Edit menu.
Select Delete Invoice.
Confirm the deletion when prompted.
Note: Deleted invoices are removed from standard reports but can be viewed in the Deleted/Voided Transaction Summary report for audit purposes.
Limitations in QuickBooks
Native Bulk Editing in QuickBooks Online Advanced:
QuickBooks Online Advanced does offer a built-in feature to edit multiple invoices simultaneously using the Batch transactions tool.
To access it, go to New + and select Batch transactions, then choose Invoices and Modify. This allows editing up to 150 invoices at once in a grid format.
Limitation: This feature is exclusive to QuickBooks Online Advanced and is not available in Simple Start, Essentials, or Plus versions. It also does not support invoices with inventory bundle items.
No Native Bulk Editing in QuickBooks Desktop and lower QuickBooks Online versions:
QuickBooks Desktop and QuickBooks Online (Simple Start, Essentials, Plus) do not have a built-in feature for editing multiple invoices at once. Each invoice must be edited individually.
Scenarios Where Bulk Changes Might Be Needed
Pricing Adjustments: Updating product or service prices across numerous invoices.
Tax Updates: Applying new tax rates to a batch of invoices.
Discounts: Adding or changing discounts for multiple invoices.
Data Corrections: Rectifying common errors like incorrect dates or descriptions across several transactions.
Workaround using Batch Actions in QuickBooks Online Accountant (for Accountants):
Limited Utility: While QuickBooks Online Accountant has "Batch actions," these are primarily for reclassifying transactions (like expenses or checks) and do not extend to detailed bulk editing of invoices for standard users.
Using SaasAnt
SaasAnt Transactions Online: For users needing to bulk edit invoices in QuickBooks Desktop or QuickBooks Online versions below Advanced, SaasAnt Transactions offers more extensive bulk editing capabilities than QuickBooks Online Advanced and works across different QuickBooks platforms.
Log In: Access SaasAnt Transactions Online.
Navigate to Live Edit: Find and select the Live Edit feature.
Set Filters: Define criteria to select the invoices you want to edit (e.g., by date range, customer, or status).
Select and Edit: Choose the invoices from the filtered list and make the necessary changes.
Submit Changes: Apply the bulk updates to your QuickBooks Online data.
Verify: Review the updated invoices in QuickBooks Online to ensure accuracy.
Note: Always back up your QuickBooks data before bulk operations to prevent accidental data loss or corruption.
Install and Connect:
Ensure you have SaasAnt Transactions Desktop installed on your computer and that it is properly connected to your QuickBooks Desktop company file. You usually need to grant SaasAnt Desktop permission to access your QuickBooks data. Refer to SaasAnt Desktop's documentation for installation and connection instructions.
Export Invoices from QuickBooks Desktop:
Open SaasAnt Transactions Desktop.
Navigate to the Export menu within SaasAnt Desktop.
Select Invoice as the transaction type you want to export.
Specify any filters if needed (e.g., date range, specific customers) to export only the invoices you intend to edit.
Click Export to export the selected invoices to an Excel file (or CSV format, depending on the export options). Choose a location on your computer to save the exported file.
Edit Invoices in Excel:
Open the exported Excel file.
Carefully edit the invoice details in the Excel file. You can modify fields like dates, amounts, item details, customer information, etc.
Important: Ensure you do not modify or delete the QuickBooks ID (QB ID) column in the Excel file. This ID is crucial for SaasAnt to correctly identify and update the existing invoices in QuickBooks Desktop.
Save the edited Excel file.
Import/Modify Invoices back into QuickBooks Desktop:
In SaasAnt Transactions Desktop, navigate to the Modify or Import menu.
Choose the Invoice transaction type for import/modification.
Select the edited Excel file from your computer.
Map Fields: You may need to map the columns in your Excel file to the corresponding fields in QuickBooks Desktop within the SaasAnt interface. Ensure that the key fields like Invoice Number or QB ID are correctly mapped.
Review and Upload: Review the data mapping and the invoices to be modified in the SaasAnt interface.
Click Upload or Modify to apply the bulk updates to your QuickBooks Desktop.
Verify in QuickBooks Desktop:
After the import/modification process is complete in SaasAnt Desktop, open your QuickBooks Desktop company file.
Review the invoices you bulk edited to ensure that all the changes have been correctly applied. Check a sample of edited invoices to verify accuracy.
Note for SaasAnt Transactions Desktop:
As with any bulk operation, always create a backup of your QuickBooks Desktop company file before performing bulk edits using SaasAnt Transactions Desktop. This will allow you to restore your data if any errors occur during the process.
Choosing between voiding and deleting is important for maintaining accurate financial and audit trails.
Voiding an Invoice:
Purpose: To cancel an invoice while keeping a record of it in your system. Voiding sets the invoice amount to zero but retains all transaction details.
Use When:
You need to cancel an invoice that was issued incorrectly but want to maintain a record for audit trails.
You need to preserve invoice numbers and transaction history.
Impact:
The invoice remains in QuickBooks records and appears in reports, but with a zero balance.
It maintains a clear audit trail, showing that the invoice was originally created and then voided.
Deleting an Invoice:
Purpose: To completely remove an invoice from your QuickBooks system.
Use When:
The invoice was created entirely by mistake and is definitively erroneous.
You need to remove the invoice completely from reports and records (though it is still logged in the Audit Log).
Impact:
The invoice is removed from most standard reports and will not affect customer balances or financial totals (after deletion).
Deletion can create gaps in invoice numbering and may obscure the audit trail, as the invoice is intended to be fully removed from day-to-day records.
Recommendation: Generally, voiding is preferable to deleting invoices. Voiding maintains a better audit trail and historical record, which is crucial for financial accuracy and compliance.
Customizing invoice templates helps tailor your invoices to reflect your brand and specific business needs.
Creating Multiple Invoice Templates (QuickBooks Online)
Access Custom Form Styles:
Click the Gear icon in the top right corner.
Under "Your Company," select Custom form styles.
Create a New Template:
Click New style in the top right corner.
Choose Invoice.
Customize Design:
Use the Design tab to customize the template's appearance:
Logo: Add or change your business logo. Note that QuickBooks Online only allows one logo to be uploaded for all templates, which can be a limitation if you operate under multiple DBAs with different logos.
Color and Fonts: Choose your brand colors and preferred fonts.
Layout: Adjust the layout and spacing of different sections.
Customize Content:
Go to the Content tab to modify what information is included in different parts of the invoice:
Header: Edit company name, address, and contact information.
Body: Choose which columns to include (e.g., item, quantity, rate, amount).
Footer: Customize payment terms, notes, and messages.
Set Default Template (Optional): You can set a specific template as the default for all new invoices.
Associating Templates with Different Business Entities:
Location Tracking (QuickBooks Online Plus and Advanced): If you use QuickBooks Online Plus or Advanced, you can enable location tracking to manage different business locations or DBAs. This allows you to assign different company names and addresses based on the location setting. However, remember the limitation of a single logo across all templates.
Limitations:
Email Template Consistency: QuickBooks Online uses a single email template for all invoices, regardless of the invoice template used.
Logo Usage: As noted, only one logo can be used across all invoice templates in QuickBooks Online. Manually changing the logo might be necessary if you need different logos for different business entities and find workarounds or third-party apps if this is critical.
In QuickBooks Online, deleted invoices cannot be automatically restored. However, you can find details of deleted invoices in the Audit Log. To recreate a deleted invoice, you would need to manually enter the information again using the Audit Log details as a reference.
To customize invoice numbering, you can:
Manual Reset: Manually enter a new invoice number in the invoice number field when creating a new invoice. QuickBooks will usually prompt if you are changing the sequence.
Automatic Sequential Numbering: To ensure sequential numbering, you can turn off the "Custom Transaction Numbers" feature in QuickBooks Online settings (Gear Icon > Account and Settings > Sales > Sales form content section). With this off, QuickBooks auto-generates sequential numbers.
If you encounter duplicate invoice numbers from the mobile app, ensure that the "Custom Transaction Numbers" setting is disabled in your QuickBooks Online settings (Account and Settings > Sales > Sales form content). If issues persist, contacting QuickBooks support may be necessary to resolve potential software glitches.
Void an invoice when you need to cancel it but need to maintain a record for audit purposes. Delete an invoice only when it was created in error and you want it completely removed from your primary records. Voiding is generally recommended for better record-keeping.
Recommended reading:
Always Back Up Your Data: Before performing any bulk edits, deletions, or significant changes, always back up your QuickBooks data. This precaution can prevent data loss from errors or accidental actions.
Consult QuickBooks Support: For recurring issues like duplicate invoice numbers or template problems, or for complex scenarios, do not hesitate to contact QuickBooks support. You can usually find contact options through the Help menu within QuickBooks Online or on the QuickBooks website.
Maintain Consistent Records: Adopt the best practice of voiding invoices instead of deleting them to maintain a comprehensive and clear audit trail. This practice simplifies audits, reconciliations, and financial reviews.
By following these guidelines, you can effectively manage your invoices in QuickBooks, ensuring your financial records are accurate, organized, and compliant with best practices.
Import Invoices into QuickBooks Online: Step-by-Step Guide
PDF Invoices Importation into QuickBooks Online: Step-by-Step Guide
What is an Invoice? FAQs & Managing Invoices in QuickBooks
Scan Invoices into QuickBooks Online