Expense management: Tax distribution using wrong main account

(1) Share

Report

Posted on by YK-04061943-0

Hi,

Entering an expense report for Office Supplies 100$, with 13$ Tax. Total is 113$ as expected but both expense category and tax portion are posting to the same Main Account tied to the expense category. The expectation is to see Office supply category post to Office supply main account and the Tax portion to post to the Tax payable main account.

Is there a setting to enforce that? The behavior should be the same as when creating a vendor invoice, in which the item and tax amounts are recorded under their respective main accounts.

Thanks in advance for the help.

Y.K

I have the same question (0)

All responses (12)

Answers (1)

Sort by

André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Y.K,

Can you tell us how the data entry was done? Probably you can share a screenshot as illustration?

Was this reply helpful? Yes No
YK-04061943-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure Andre Arnaud! Please find the screenshots below. Pretty straightforward with simple Expense category setup with a main account and an Item sales tax group.

The sales tax group is tied to a Ledger Posting Group hitting a different main account, 200xxx

Here are screenshots of the expense report

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Not sure if other people can see the screenshots, but for me, the screenshots did not display properly on the forum. This may be a problem with the forum, please try to upload it again to see if it works.

Best Regards,
Hana

Was this reply helpful? Yes No
YK-04061943-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I do see the screenshots. Initially, one of them didn't upload but I can actually see all of them.

Y.K

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, I'm not able to see the screenshots. I will try to contact the administrator of this forum to check if there is a known issue.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I got a quick reply that there should not be an issue. We checked the page source and it looks like you shared an URL to an image that is within your own email attachments. This is visible for you, but not for us as we don't have access to your email folder.
Can you try to post the images in a different way?

Was this reply helpful? Yes No
YK-04061943-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

That makes sense. I just updated by taking actual screenshots and pasting them. Can you guys see the images now? Thanks!

Was this reply helpful? Yes No
YK-04061943-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone with a suggestion regarding this issue? Are you able to see the screenshots now? Thanks!

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Y.K.,

Yes, the screenshots are visible now. Can you also check what main account is set up on the Tax ledger posting group linked to the Tax code that is used for the combination of the Tax group and Tax item group?

Was this reply helpful? Yes No
Adis 6,830 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,

I would suggest to go to the ledger posting setup, select your desired line, delete it and create a new one with the same setup as before deleting. In case you recently changed something on the line, it can be buggy. We havent figured out when it happens, but it does and deleting the line solved the issue. It didnt happen when creating a line without changing it.

Kind regards, Adis

Was this reply helpful? Yes No