My invoice is not mapping properly to the Profit and Loss report. For example the account associated with the item on the invoice is Interviews-ABC and it shows up on the Profit and Loss report as Interviews-Other.
It's possible that the account associated with the item was recently changed that's why it's showing the wrong account in your Profit and Loss report. Let's review the item to verify if it's associated with the Interviews-ABC account. Here's how:
Click Sales from the left menu, then select Products and Services.
Find the item that is associate with the Interview-ABC.
Then, click Edit under the Action column.
In the Income account section, review the associated account. If it changes, modify it if needed.
This can happen if you change the account on an item and then as you save it you answer No to update existing transactions.
If your goal is to update existing sales that use the item to use it's current account, but they're now different, then do this:
1) Edit the item and change the account on the item to the account that the transactions that you want to change use: "Interviews", in this case (which appears as "Interviews - Other" on the P&L as it has sub-accounts. Save the item and answer No to update existing data.
2) Edit the item again and change the account to be the desired account. Save the item and answer Yes, to update existing data.
When you do this all of the transactions that use the Interviews account will update to the new account.
Thanks for your feedback. If I run the Sales by Item Summary report the account Sales Service-Impexium The problem occurs when I run my Profit & Loss Budget v Actual report. On this report, the transactions for Sales Service-Impexium are showing as Sales Service-Other. I hope this helps.