Error:
Error while posting fees for payoutID, expenses post to QuickBooks failed due to there is an invalid reference to QuickBooks CheckExpenseLineitemAccount "Shopify Fee" in the Check Expense Line. QuickBooks error message: Invalid Argument. The specified record does not exist in the list
Cause of the issue:
This issue typically occurs when trying to post Shopify payouts into QuickBooks. This error is related to the fee or expense item mapping in QuickBooks. Below are some common causes:
Missing or outdated Shopify Fee account/item in QuickBooks
The mapped fee account might no longer exist or have been renamed/deleted in QuickBooks.Corrupted or incomplete item list in Webgility
If Webgility Desktop does not have an updated item list from QuickBooks, it may try to reference a missing or incorrect account/item.
Incorrect configuration in fee settings
The expense settings for payout posting may reference a previously valid but now invalid QuickBooks record.
Steps to fix:
Redownload the latest accounting data from QuickBooks
Follow the steps in this helpful article on How to Download the Latest Accounting Data
Save Posting Expense and Fee Settings Again
In Webgility Desktop navigate to Connections in the menu options, then goto Accounting/POS/ERP and then click on Sync Settings.
Navigate to Expenses and Fees section,
If you have opted to post fees as a line item, then verify and save the active Shopify Fee items from QuickBooks.
If you have opted for Bill/Check, then verify and save all the active options under its Setup and save.
Now click on Save & Close. This revalidates the current configuration with the updated item and account list.
Retry Posting the Payout
Try reposting the payout again. With the updated configuration and data, the payout should post successfully without the error message.
If the problem persists, contact Webgility Support for further assistance.