Edit or Delete Items in the ConnectWise Accounting Interface

Two options exist when you need to fix a record that has already been posted to the Accounting Interface: unbatch the individual item, or delete the entire batch.

• Unbatch — targets a single invoice, expense, freight, or product record. Other items in the batch are unaffected.
• Delete batch — removes all items in the batch, letting you edit any of them before re-sending.

Note: Before sending corrected records to your accounting package, manually delete the originals from that package. Failing to do so creates duplicates.

Find a GL Batch ID

Before unbatching or deleting, locate the batch ID for the record you need to fix.

Record type	Where to find the GL Batch ID
Invoice	Finance > Invoice Search > GL Batch column
Expense	Time & Expense > Expense Entry Search > select the expense > Audit Trail
Freight	Procurement > Purchase Orders > Freight GL Batch column
Product	Procurement > Purchase Orders > select the PO > Products tab > GL Batch column

Unbatch Items

Unbatching lets you edit one record without touching the rest of the batch. After editing, you can rebatch the item into its original batch or send it as part of a new batch.

Invoices

1. Go to Finance > Invoice Search and enter the invoice number.
2. Select the invoice.
3. Select MORE > Unbatch, then select OK.
4. Set the invoice status to an open status and save.
5. Edit the invoice, then set the status to a closed status and save.
6. Associate the record with a GL batch using one of these options:
   • Select MORE > Rebatch to add the updated details back to the original batch ID. This does not push changes to your accounting package.
   • Open the Accounting Interface screen to include the item in a new batch and send it to your accounting package.

Expenses

1. Go to Time & Expense > Expense Entry Search.
2. Select the expense entry.
3. Select MORE > Unbatch, then select OK.
4. Reverse the expense sheet to set the status to an open status.
5. Edit the expense, then submit and approve the expense sheet to close it.
6. Associate the record with a GL batch using one of these options:
   • Select MORE > Rebatch to add the updated details back to the original batch ID. This does not push changes to your accounting package.
   • Open the Accounting Interface screen to include the item in a new batch and send it to your accounting package.

Purchase Order Freight

Note: Freight and products on a purchase order must be unbatched individually.

1. Go to Procurement > Purchase Orders and select the PO number.

2. Select MORE > Unbatch.

3. Set the purchase order to an open status and save.

4. Edit the freight amount and select Save.

   Note: To edit the tax code, all product records on the purchase order must be reopened and unreceived first.

5. Set the purchase order to a closed status and select Save.

6. Associate the record with a GL batch using one of these options:

   • Select MORE > Rebatch to add the updated details back to the original batch ID. This does not push changes to your accounting package.
   • Open the Accounting Interface screen to include the item in a new batch and send it to your accounting package.

Purchase Order Product

1. Go to Procurement > Purchase Orders and select the PO number.
2. Go to the Products tab and select the Product ID.
3. Select MORE > Unbatch.
4. In the Receiving Information pod, clear the Closed checkbox and select Save.
5. Select Unreceived.
6. Make the required adjustments and select Save.
7. Associate the record with a GL batch using one of these options:
   • Select MORE > Rebatch to add the updated details back to the original batch ID. This does not push changes to your accounting package.
   • Open the Accounting Interface screen to include the item in a new batch and send it to your accounting package.

Delete a Batch

Deleting a batch removes it entirely, unlocking all records in it for editing.

Note: If you previously unbatched items, rebatch them before deleting the batch — ConnectWise requires this so the system can identify which items belong to the batch being deleted.

Before starting, confirm there are no pending items waiting on the Accounting Interface screen. Any unposted items present during deletion will be mixed into the batch you are removing.

1. Go to Finance > Accounting Interface > Open Batches tab.

2. Select the checkbox next to the batch or batches you want to delete.

3. Select Actions > Delete Batches. Note the batch ID — you will need it later.

4. Locate the affected records and make the required edits.

5. In a new tab, go to System > Setup Tables.

6. Under Accounting Package, temporarily clear the Direct Transfer checkbox.

   Important: Clearing Direct Transfer removes all customized checkboxes in that setup table. Note your current selections before proceeding so you can restore them. If QuickBooks is selected as the accounting package, switch it to Other to allow desktop export.

7. Select Save.

8. Return to the Accounting Interface screen.

9. Select only the items that were not edited. You will export these to a desktop file to prevent duplicates in your accounting package.

10. Go to the Creation tab and enter the original batch number in the Batch ID field.

11. Select TRANSFER to create the export file. The file saves to your desktop. Do not re-import these items — they are already in your accounting system.

12. Go back to the Accounting Package setup table and select the Direct Transfer checkbox. Restore any other settings you cleared in step 6.

13. In the Accounting Interface screen, go to the unposted tab, locate the item you edited, and select it. Import it into your accounting package with the next batch.