I've imported trial balance data for 3 years, using "Historical Data" for A/R and "HD Vendor" for AP entries. They appear on schedules. How do I clear offsetting balances

Hi Joe, to remove the Accounts Receivable (A/R) and Accounts Payable (A/P) entries from your schedules, you'll need to create and reverse journal entries for both accounts.

Here's how for Accounts Receivable:

1. Go to + Create, then select Journal Entry under the Other column.
2. Set the Journal Date to the end of the time period.
3. On the first line, choose the account affected by the invoice in the Account column.
4. Enter the amount in Debit, and add a Description.
5. In the second line, select Accounts Receivable (A/R) from the Accounts dropdown list. The amount will automatically populate in the Credits column.
   Note: If splitting across multiple customer accounts, adjust the amount to reflect each customer's individual sales tax.
6. Choose the Customer from the dropdown list in the Name field.
7. Click Save and close.

Next, for Accounts Payable, note that the Credit account is typically an expense or liability. Here's what to do:

1. Follow the similar steps by selecting the affected expense/liability account in the Credits column on the first line.
2. On the second line, select Accounts Payable (A/P), and the amount will auto-fill in the Debit field.
3. Choose the Vendor in the Name field.
4. Click Save and close.

Once the accounts receivable or accounts payable journal entry is created, you need to reverse it.

Here's how:

1. Find the journal entry you've created in the Search bar.
2. Open the entry, click Revert, and set the Journal Date to one day after the original entry.
3. Select Save and close.

Also, a common cause of balances in Accounts Receivable or Accounts Payable is unapplied payments. For more details on identifying and fixing these, refer to this article: Unapplied payments.

Lastly, I recommend consulting an accountant for further guidance, as they can ensure proper handling of these entries, confirm compliance with accounting standards, and address any underlying issues in your financial records.

If you have further concerns or additional questions, please feel free to click the Reply button. The Community team is always here to help!