web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Paying 2 vendors from 1 invoice

(0) ShareShare
ReportReport
Posted on by 30

Purchasing goods/services from foreign vendors require Canadian non-profit organizations to self-assess tax amount and remit the amount to the government. For instance, my organization purchased $100 CDN web design service from a US company, and the tax rate is 13% in Ontario. I need to post 1 invoice that will do the following:

Dr. Web Design Service Expense      $100

Dr. Web Design Service Expense    $13

Cr. Accounts Payable     $100

Cr. Accrual      $13

Basically I need to pay 2 vendors based on 1 invoice. I need to post these purchases throughout the month, and at the end of the month, I would enter 1 invoice for Canada Revenue Agency (equivalent to IRS in this context) where I debit the accrual and credit Accounts Payable. 

When I tried doing this, I got error messages (see below). Is there any way of accomplishing this.  Any suggestions?

Test-invoice.png

**20010 - Accounts Payable; 20030 - Accrual; 600-53150 - Expense Account **

6787.Error.png

*This post is locked for comments

I have the same question (0)
  • Tami Farrelly Profile Picture
    5,080 on at

    We have GL accounts setup for the separate taxes (used to be PST\GST).....that the taxes of a transaction post to that account........ these are then submitted to CRA once a month?

    Tami

  • Verified answer
    twelvestrikes Profile Picture
    3,657 on at

    Hi Mahabub

    Most clients of mine don't setup the CRA as vendor for remitting their HST/GST remittances.  They usually enter this transaction in Bank Transactions.

    A very slick way to have the self assessed HST calculate for you is to do the following:

    Under Company setup > Options

    Enable the option to allow reverse taxes.

    You then setup a new tax detail for this reverse tax and call it something like P-HST-ON-SELF  (HST on Purchases Ontario Self Assessed). You will also need to setup a tax schedule for this as well.  You can either use your existing HST GL liability account or you can create a new GL Liability account for HST Self Assessed.

    For those transactions that you need to self assess HST you use this self assessed tax schedule.  It will drive the liability side to the GL account you selected in the Tax Detail setup.

    The debit side will be expensed (or capitalized) as you have in your example above.

    You should try this in a test company first.  You may also want to engage your GP partner who may provide additional guidance on this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans