My notebook no longer has a "Y" key and it's a real pain.

I did the same entry in Make Other Payment as I did the first time and I can control it with Ctrl-Y after I enter a tax code as I indicated.  My file has more than two taxes though, so I have to use Ctrl-Y.  You only have GST and QST so you should be able to click in the columns and change the numbers.  If not, try Ctrl-Y.

The image below shows the taxes for the total invoice, not the line item, for the entry you just posted.  Please also be aware in this test file, I have GST and QST being sent to the same accounts so the journal entry shows them both combined.

I'm not sure why you are not able to reproduce this, unless I have the entry concepts wrong.  However, regardless you should have a $40.01 expense just as I do because otherwise your journal entry looks ok to me.

Total amount of the FedEx invoice' I received is $280.41 which is what you saw in the print screen I put in my previous reply. Here's the actual breakdown as per the FedEx invoice

GST Canada:  $234.41

Advance clearance fee: $10.00

GST charged on clearance fee: $2.00

QST charged on clearance fee: $4.00

Since this was entered in Other Payment, I went back in it, edited the entry and noticed that, as you can see,  I can indeed skip the amount column, enter G as the tax code and then the GST amount.

Now I just have to figure out what I was doing previously that was preventing me from doing this. After I do, I will edit all previous entries and do the same with them. See what kind of result I get and compare with the spreadsheet I'm working on

If I get funky results, I'll just restore everything using the last backup I did

Seems to work as it does show in my report with the same total still

Marc

Marc

Please make sure you do a backup before you do anything and please make sure you pay attention to details or you may make things worse.

In my example, on the first line, I did not use an account, you did, but you don't need to.

You also indicated $234.41 + $10 + $2 + $4 = $281.41.  I just don't see it.  It's missing $30 because you entered $40.01 not $10 in the entry.

The only reason to go back and fix anything is to make sure it is correct.  Based on what you have shown me (other than the missing $30, the expense is correct and the tax is correct, so do you really need to go back and adjust?  Do you really need to change your data entry method?

I only jumped in here to help MTLFALL make sure the entry showed on the Tax report because Smithco's option would not allow for that due to a lack of tax code.  Many people are not aware of the technique I used above so I thought it worthwhile mentioning it.  However, it is up to you if you wish to adjust the past.  Make sure that if you go back to previous remittance periods, the absolute remittance numbers should not change.  I'm not sure it's worth the work if it is a lot of entries when there are other methods of determining the proper tax to remit.

Hi Marc,

Try to enter 0 in the amount column, if you cant skip this column.

Mina

I think for people who don't use tax report to file gst remittance, omitting the tax code will not be a problem as long as you put your account number (2315 Gst paid on purchases)there. However, for me I don't like to see this inconsistency between my gst account and tax report, so I choose to use the tax code instead of leaving it blank there. I also put my account number(2315) there too.

To file remittance according to GST online filing report is a very good option.Thanks for sharing!

Mina

Whoops, typo,. You are correct Richard, the advanced clearance fee FedEX charged me was 40.00.

As far as doing unnesccessary work goes, not to worry, I'm doing it in a spreadsheet first, reviewing, comparing with SAGE and only then will I do adjustments. I have no intention to mess things up believe me.

Cheers,

Marc

You can also enter the lines as the customs & brokerage fees for 10.00; enter the appropriate tax code to charge GST and QST, then modify the tax amounts by clicking on the magnifying glass beside the tax amount.

AmyGurl,

While that is technically correct and it works just fine, I like process and never teach people to do the same thing two different ways.  If people get used to doing it that way in Purchases, then they do it the same way when necessary in Sales.  Then the invoice indicates a difference when printing so the customer getting the invoice must now add the sales tax line with the Adjustment to the sales tax line to get the final total.  The invoice looks weird but can be presented correctly if the sales tax is adjusted on a line item itself instead.

Hi there,

I read all the postings above and they are really helpful. I still have a question here, sorry if its a silly one.

Our company (at Ontario) has Willson international as the broker, and the GST $99.66 is listed on the Willson intl invoice, but my boss wrote a check paying GST$99.66 directly to the CRA.

Any advice on how to do this payment entry?

Thanks for help!