Pro-rate tax and freight to expense lines in AP

(0) Share

Report

Posted on by Ellen Ryan

700

We have an unusual way of recording our taxes and freight paid on purchases within our organization. We record them to the same GL expense account as the items being purchased. When the invoice arrives and we receive/match it, we cannot use the freight and tax boxes at the bottom of the purchase order entry screen since those are tied to only one GL account. We have to manually calculate and pro-rate the amount to each item being purchased (especially when the items are being charged to several GL expense accounts).

Does anyone else process tax and freight in this way and have you found a more automated way of calculating? Our old software had a pro-rate button to handle this, but I have not found that feature in GP.

We are using GP v10

*This post is locked for comments

All responses (2)

Answers (0)

Jeffrey Gard 225 on at

Like (0)

Report

Re: Pro-rate tax and freight to expense lines in AP

JeffG: Congruent Software Seattle: For a client of mine I used the landed cost functionality for taxes. I created a landed cost detail and schedule going to AP accrual account. The landed cost detail was based on a % of cost (the tax rate). When the item is received the tax liability gets coded to the GL cost account for the item. The Invoice match would move it from AP Acrual to AP. With shipment/invoice it go to the item cost account and AP.

Landed cost is designed for distributing freight and acquisition cost, so freight works similarly.
cgardner1031 5 on at

Like (0)

Report

Re: Pro-rate tax and freight to expense lines in AP

We are using GP 9 and have the same problem - would love a solution!