Only 1 of my GST entries is not showing on "Tax Report" but shows in General Ledger

I recently discovered my GST account was not balanced so when I went back to the beginning (Jan 1, 2014 to March 31, 2014) to pull that report to see if I had accidentally posted something after the fact, I discovered that 1 entry did not show on that quarterly GST report but that same amount/entry showed on the General Ledger report under the correct GST account. The entry was posted in the expense journal so the GST should have been recorded correctly (I know that if you post it in the General Journal, you need to enter the "sales tax"). When I try to pull up entries for the date that it was posted (using Journal Entries report), no entry shows for that date at all. The only way that I can pull up the entry is to pull up the General Ledger report for the GST paid account and click on the entry from that report. I have never had this happen in all the years that I have been posting entries on Simply/Sage, nor have I had it since. My GST account is out exactly that amount so I know that this is the issue. Is there a glitch in the program? Or did I do something wrong? Anyone have this issue in the past and do you know how I can fix it?

  • 0
    ...When I try to pull up entries for the date that it was posted (using Journal Entries report), no entry shows for that date at all.. - did you check the box included 'corrections' ?

    does maintenance, check data integrity reveal any issues ?
  • 0
    The tax report shows only those entries that were posted with a sales tax code. If you didn't use one on that entry, it will not show on the tax report.

    You should be able to go an adjust the entry and put one on but take a backup of your file before you start playing.

    Otherwise, just post the remittance properly with the proper amounts and make a note on the report if you wish to use it.
  • 0 in reply to Richard S. Ridings
    Thanks Richard. I did post the entry with a sales tax code (it was posted in the Expense Journal which automatically does this) so it was done properly. That is what is so baffling. Any other ideas?
  • 0 in reply to Roger L
    Thanks Roger. Data integrity is fine. I did discover why I couldn't get the Journal Entries. For some reason the "Only entries posted after year end" was checked. Once unchecked my entries showed up. Still very puzzled as to why the one entry does not show up on the tax report but shows up on my GL? Any other ideas?
  • 0 in reply to smobile
    Because you have been so diligent that only one is missing, I assumed you would have used one on this entry as well. However, there are only two other reasons I can think of.

    One is the date range of the report vs. the date on the entry. If the entry date is within the reporting range, then it is not the problem.

    The only other reason I can think of is the options you checked when running the report, may not include that entry for some reason. Are all the tax statuses selected?
  • 0 in reply to Richard S. Ridings
    Date range is correct. All tax statuses are selected. In order for me to talk to Sage tech, they want me to pay $250 to upgrade to the 2015 version. I don't think it's my error so I shouldn't have to pay for this to get tech support. I was hoping this forum would answer my question but hope is fading fast:-) Thanks for your suggestions.
  • 0 in reply to smobile
    I've always been of the belief that if you find something that is frustrating you or not giving you the information you expect, do it some other way. I personally never use the tax report because of two issues. 1) you must use a tax code, 2) your report is date sensitive and will not pick up anything posted before the date range, but after the time you posted the last remittance.

    Having said that, to find the problem, you have to go back to basics. Recheck everything (journal entry on the actual entry, settings for the tax code you used, dates, report settings, etc.). Unfortunately, it looks like you have done that a few times.

    The obvious answers have already been dealt with here so it is hard for us to help more because we can't see the data.

    Without e-filing or posting, what does the eFile GST report look like (assuming it exists in your version)? It should match the numbers on your balance sheet and income statement.

    If you want me to have a quick look at your report, send me an email from the link in my profile. I'll take 10 minutes to do that this morning if you want.

    Tech support at this point only covers the 2015 version. All other versions are out of service.
  • 0 in reply to Richard S. Ridings
    Thank you so much for your time and your offer to look it over! As a last resort, I reversed the entry and re-posted it and it now shows on the GST report. Although the mystery remains as to why it didn't show up the first time, I think all is good now. Thanks again!
  • 0

    i compared my G/L to HST/GST etc and my Sales portion did not match 

    My Sales for HST/GST (etc) for recent Oct-Dec 2022 did not match my G/L. Everything is taxed both supplier/customer. Not sure what is wrong??