Sales Tax not adding up in the General Journal

Okay so I am entering some vehicle expenses in the GJ.  I have entered it as follows:

5784 Travel & Entertainment     64.98
2315 GST Paid on purchases     3.10
1060 Chequing Account                                  68.08

Then I need to click on the sales tax button, and it is using the "2315 GST Paid account", I have to type "G" in the "tax code" and tab over and it will calculate.  The part where I am confused is that it says "Amount subject to tax" is 62.00

Now I realize I may be entering this wrong because the 64.98 amount actually has the PST in there, but the GST amount is still the amount charged on the subtotal.  Now even if the program was some sort of super computer mind reader and knew I did that, the numbers still don't add up....where the heck does the 62.00 come from??  Do I need to manually enter 64.98 or is 62.00 correct.

Attempting to add a screen shot, hopefully that works lol

Parents
  • 0

    you indicated to sage that the gst amount is 3.10

    and you selected G as the tax code - sage knows the rate is .05 so

    x*.05 = 3.10

    x=3.10/.05 = 62.00

    you could be using 'pay expenses' to record this (instead of a GJE) - in Alberta we have just GST, but we can create a tax code Gi (gst included) - I type in 68.08 as the amount and Gi as the code => sage automatically calculates the expense amount and the gst amount

    I'm assuming that it's possible to set up a GPi (gst and pst included) tax code

  • 0 in reply to Roger L

    Would it just make more sense to make a "pst paid on purchases" account and track the pst even though I don't charge it out at all?

  • 0 in reply to LAger

    If the tax codes are set up properly then when you enter the amount of the purchase as 62.00 the GST will show as 3.10 because it is 5% of the purchase price. The provincial tax will be calculated at 4.8% or $2.98 and it will be added to the 62.00 to be expensed. I am assuming from your entry (screen shot) that the provincial sales tax is non-refundable and it is 4.8%. If any of these numbers are not correct then the tax codes need to be adjusted appropriately.

  • 0 in reply to Alwyn

    Create account for pst paid on purchases and pst charged on sales
    Setup -> Settings -> Company -> sales taxes -> taxes
    Tax PST
    Tax id PST
    Exempt no
    Taxable no
    Account to track tax paid on purchases
    Account to track tax paid on sales
    Report yes
     
    Setup -> Settings -> Company -> sales taxes -> tax codes
    Code Pi
    Description GST @5%; PST @4.8%, non refundable, included
    Use in all journals
     
    Tax code details – 2 lines
    1)
    Tax GST
    Status taxable
    Rate 5
    Included in price yes
    Is refundable yes
     
    2)
    Tax PST
    Status taxable
    Rate 4.8
    Included in price yes
    Is refundable no

    Pay vendor expense of 68.08, using 'pay expense' will result in this entry

    Account Number     Account Description         Debits         Credits
    2315               GST/HST Paid on Purchases     3.10               -
    5730               Motor Vehicle Expenses       64.98               -
    1060               Chequing Bank Account             -           68.08
     
     
     
    Create sales invoice for $100.00 will generate this entry   
     
                                                                        

    Account Number  Account Description      Debits         Credits

    1200             Accounts Receivable       100.00               -
    2310             GST/HST Charged on Sales      -           4.55
    2340             PST Charged on Sales           -           4.37
    4100             Consulting Revenue            -           91.08



  • 0 in reply to Roger L

    um.. I pasted 2 images in rich text mode - and it displayed my post as I wanted

    but after posting, I don't see the images - so I'm inserting media

    left is pay expenses, right is sales invoice

  • 0 in reply to Roger L

    I have to thank you, this is all really helping!  My business just incorporated Sept. 3.  I have about a months worth of gas receipts and vehicle expenses while we shopped around for the Semi we eventually bought.  I was told I could claim those expenses.  This was the reason I was doing it in the Journal so that I could write a note of what it was and the original date.  The only issue I am having now is the expenses are from our personal vehicle, not a company vehicle.  So do I use Vehicle expense, or travel and entertainment....or should there be a new account?  Can I add them all up and enter it as one transaction?  Then enter things normally after that?

Reply
  • 0 in reply to Roger L

    I have to thank you, this is all really helping!  My business just incorporated Sept. 3.  I have about a months worth of gas receipts and vehicle expenses while we shopped around for the Semi we eventually bought.  I was told I could claim those expenses.  This was the reason I was doing it in the Journal so that I could write a note of what it was and the original date.  The only issue I am having now is the expenses are from our personal vehicle, not a company vehicle.  So do I use Vehicle expense, or travel and entertainment....or should there be a new account?  Can I add them all up and enter it as one transaction?  Then enter things normally after that?

Children
  • 0 in reply to LAger

    you should already have an account called

     '2640 loans from owner' (or from shareholders)

    create a vendor called 'personal expenses'

      on the 'options' tab, set the expense account to '2640 loans from owner' (or from shareholders)

    use 'pay expenses'

      by cash

      pay to the order of 'personal expenses'

      change the date to when the expense occurred

      first line will automatically be 2640 loan from owners (from vendor setup)

         amount = expense amount as a negative, say -100$

      second line

         account = 5730 vehicle expense

         amount = 100

         tx = Pi

      you can use the 'comment' at the bottom to record what the expense was

      the total amount of the invoice is 0.00 (no money is coming out of the bank)

      the entry created when you post will be

      db 4.55 gst paid on purchases

      db  95.45 motor vehicle expense

      cr     100.00  loans from owners  

  • 0 in reply to Roger L

    when you want to reimburse yourself for these personal expenses

    use 'pay expenses'

     by cash or cheque

     pay to the order of 'personal expenses'

     from 1060 chequing account

     change the date to when you are paying back the expenses

     first line will automatically be 2640 loan from owners (from vendor setup)

        amount = total amount owed that you are paying back, say 500$

      when you post, sage will

      db  500.00   loans from owners  

      cr   500.00   bank