[?] Subscribe To The Bookkeeping Blog

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

Home

Take A Tea Break With Me Today The Site Map
The Blog
The Free Ezine

The Receipts Organization The Suggestions
The Vehicle System
The Paperless System
The Proven System

The Compliance Taxes - Canada The CRA Compliance
The Payroll Taxes
The GST HST
The T2125 Form
The CRA Tax

The Compliance Taxes - U.S. The IRS Compliance
The IRS News
The Payroll Taxes

The Store Front

 The Book Shoppe
The Freelancer
The Online Exams
The Basics
The Excel Lessons
The Forum
The Support

The Free Training

 The Tips
The Practice
The Financials
The System
The Plan
The Help

The Back Office

 Contact/Meet Me
Hire Me
Site Policies

Sales Tax Return Already Filed

by Lynne
(BC)

Cannot File Prior Period GST/HST Tax Return

Cannot File Prior Period GST/HST Tax Return

Cannot File Prior Period GST/HST Tax Return A Sales Tax Return Already Exists

I am using my newly purchased QB and filed my current quarterly Sales Tax Return.

Now I am entering data retrospectively for the last fiscal year. I want to File Return and Receive Refund from Agency, but QB says I cannot file - return already filed. I did not do this for any period last year, but have done it for in current year.

Do I have to manually create an invoice for Sales Tax Agency?

Many thanks.



image of fancy scroll lines






Hi Lynne,

Sorry I took so long to get back to you. I needed time to experiment a bit.

I recreated your error message ... you can see it in the first picture.

Next I tried to re-file the last return so that I could clear prior periods. That created the error message in the second picture above.

I think you are going to have to manually prepare each payment and/or refund. Make sure your GST/HST Payable account is balanced prior to filing your next GST/HST return.

Take a backup before you file your return ... which you should do anyway in case something goes wrong.

What is going to happen is that when you file your next legitimate tax return in QuickBooks, it is going to clear all your prior periods ... which is why I said to take a backup BEFORE you begin and make sure you are balanced.

You are going to have to manually create your GST/HST return that you actually file with CRA as your QuickBooks report will have carry forward balances from your prior periods.

I am wondering how you got your opening balances for QuickBooks setup if you are retroactively going back and entering data. Usually, you enter your opening balances for the time period where you want to begin and go forward ... not backward ... in time.






P.S. I would like to remind you there is a difference between information and advice. The general information provided in this post or on my site should not be construed as advice. You should not act or rely on this information without engaging professional advice specific to your situation prior to using this site content for any reason whatsoever.

Comments for
Sales Tax Return Already Filed

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 14, 2011
Rating
starstarstarstarstar 		Thank you for your response
by: Lynne

Hello Laura and sincere thanks for your response. I am encouraged that I had read the situation correctly, even though I may have created a problem that I can't deal with. Do I have to create an invoice to Tax agency, then receive a payment for the earlier periods?

The answer to your question is that I didn't have any opening balances ....

I'm sure mine isn't the first sorry story you have read ... I used to have a very competent bookkeeper run my year end in Simply accounting, prepare the tax return and send me a back-up file to start the new fiscal year with. I moved far away and she doesn't use email, plus I had used QB tax software for several years and thought this would be a good time to convert to QB accounting.

Unfortunately, I couldn't find anyone who could/would export my SA data to QB so I could make the data entry for the last fiscal year. I started using QB to keep data entry for this year upto date and file Sales Tax returns. As my tax filing deadline was approaching and I still hadn't found anyone, I started entering the previous fiscal year data, hoping that I would find someone to run the year end for me, hence the retospective entries. My tax filing deadline is 14 days away and I have a lot to do. Which leads me to ask for further help about entering the last fiscal year opening balances in order to be able to close the year and prepare tax filing. Is this something I should ask in a new post?

Many thanks for this wonderful site and opportunity to ask questions.
Mar 14, 2011
Rating
starstarstarstarstar 		Opening Balances in QuickBooks
by: Laura

Hi Lynne,

As sorry as your story may be, it did make me smile today ... actually it gave me a great big grin ... so thank your for that!

To enter your opening balances, take your final trial balance or financial statements from the last time your bookkeeper did your books in Simply.

Open up a journal entry in QuickBooks and enter in all your balance sheet account balances except for accounts receivable and payable, sales tax, your bank balance and retained earnings. These accounts will get setup separately. Your offsetting entry for this journal entry is the Intuit account called Opening Balance Equity.

Quickbooks will only accept one A/R or A/P in a journal entry and it has to be on the first line. This means your next step is to enter each item outstanding on your aging reports in a journal entry ... one item per journal entry ... again with the offsetting balance to Opening Balance Equity.

Do the same thing with your outstanding checks or deposits in your last / final bank reconciliation in Simply ... and setup your payable or receivable for GST/HST Payable. The offsetting balance will always be to Opening Balance Equity.

If you've done it correctly, the balance in Opening Balance Equity will be equal to your retained earnings. When you are balanced and happy, clear this account to Retained Earnings and hide it as you shouldn't have to use it again.

For your GST/HST Payable, I think but I'm not 100% positive as I haven't done it before, you will have to use Write Cheque to pay the GST/HST for the prior periods ... ignoring the warning about using the Sales Tax Module. Just make sure you select the appropriate "tax item" portion in the coding area of the cheque.

By the by, your Payee will not be "Tax Agency" but Receiver General.

If you had a refund, then you will have to "Make Deposit" following the same general principal as above. Here your customer your be Receiver General - Receivable.

Just to be safe, I'd be making backups after every step and putting a meaningful name for each backup file in case you muck something up or the solution doesn't work and we need to come up with a different solution.

I hope I covered everything!
Mar 17, 2011
Rating
starstarstarstarstar 		Outstanding willingness to help and professional insight
by: Lynne

Thank you again Laura

I will have to work through your instructions.

"This means your next step is to enter each item outstanding on your aging reports in a journal entry ... one item per journal entry ... again with the offsetting balance to Opening Balance Equity."

I am confused by "each item outstanding on your aging reports". Please could you clarify.

I have been quoted between 24 and 48 hours by a bookkeeper with 30 years experience to enter the opening balances for me and close the year. I have 146 purchases and 8 sales invoices. Is it me or do you think this sounds a lot. Val used to spend a couple of hours, which included preparing the tax return.

I am truly grateful for your time and am glad that you enjoy the website work - I love the Site Build it concept.

Regards,
Lynne
Mar 17, 2011
Rating
starstarstarstarstar 		Entering Opening AR/AP balances
by: Laura

Hi Lynne,

If you have, for example, 2 customers with an accounts receivable balance and 7 venders with outstanding payable balances at Dec 31 (assuming that is your year-end), you need to enter 9 separate journal entries establishing the opening balances.

Account Receivable Entry - 2 times - one for each customer

Dr A/R Customer Name
Cr Opening Balance Equity

or

Account Payable Entry - 7 times - one for each vendor

Dr Opening Balance Equity
Cr A/P Vendor Name

If you don't have an aged AR and/or AP report for the last year-end your bookkeeper did for you, you are going to have to go through your ledger to determine what the balances for each individual customer or vendor is/was. You are balanced when this sub-ledger equals the control total in your general ledger.

Some bookkeepers have minimum billing amounts or fixed fee charges for some work. Normally a bookkeeper will cost less than an accountant, so the more work you can have them do, the lower your overall fees will be.

Hope that helps.
Mar 19, 2011
Rating
starstarstarstarstar 		OBE question
by: Anonymous

Hello Laura

I did not have the confidence to make the journal entries. I was afraid that my earlier transaction data entries would have errors that would affect the balances, giving me more problems to solve. As this company has so few transactions, I decided to start from scratch and create a new company. I renamed the old company first.

I have learned a lot from watching what happened as I made each entry. I also saw how I create problems in not defining accounts and sub accounts sufficiently. This confirmed my earlier fear in my first paragraph here and I'm glad I saved myself the heartache of trouble shooting them.

I am almost in balance now (on the new company), but of course almost means NOT. (I am a vegan and a friend once tried to persuade me to eat a cake which only had 'very little egg' in it!) Balancing books is like being a vegan - you either do or you don't :-)

I checked all my typing for errors - there are none. I made the mistake (I think) of entering retained earnings. Then reading your earlier post again, I decided to zero the journal. I hope this was correct?

I dont understand why Common Stock (Equity) is showing on the journal as a minus. Is it because my retained earnings are negative? However, the difference I am looking for (to achieve the retained earnings on last years balance sheet) is equal to bank + accounts payable.

Am I on track? What is the next step please?

I feel pleased that I have understood far more from your responses than I have ever done before. I have identified that one-to-one training on my company would help me the most - as it has real meaning to me. Have you considered offering this as a chargeable service using Zoho or similar, where we can work on the same screen, watching what the other is doing? Perhaps you do already and I have missed it. I am very focused elsewhere at present and look forward to following every link on this site once this tax return is filed!).

As always thankyou so much - you have been incredible.

Regards Lynne
Mar 19, 2011
Rating
starstarstarstarstar 		Contact Me
by: Laura

Lynne,

There you go making me smile again! Thanks.

Contact me and I can arrange a time to look at what you've done online. I'll let you know my fee per hour and you can decide from there.

Click here to add your own comments

Join in and write your own page! It's easy to do. How?
Simply click here to return to Learning QuickBooks


© 2009-2012 Lakeshore Bookkeeping Services
All Right Reserved. Do not duplicate without permission.

Inquire about my virtual bookkeeping services in Canada today.
Committed to educating & providing support to work from home business owners.

SIMPLE EASY
Office Filing System

Learn How to Organize Files
In Under 30 Minutes
$47

Bookkeeping In A Box eBook- choose the Canadian or US Version

Download eBook Canadian

Download eBook U.S.



You can delegate responsibility but you can't abdicate it!



2 Bookkeeping Tests
Prescreening Tool or Study Aid
350 Questions

includes answer key,
Bookkeeping Basics Webcast
and more

Bookkeeping Test Questions and Answers Bookkeeping Test Online Basic Bookkeeping Training

$49 USD
LIFETIME ACCESS

Click on exam booklet to order
Click here for more information

How to Use This Exam:

(1) As part of your interview process when hiring a bookkeeper.

(2) To self assess your bookkeeping skills.

(3) As a practise test before writing your bookkeeping certification exam.



Learn How to Turn
Your Piles of Paper
Into an Organized
Electronic System

Paperless Document Organization Guide

Click on the picture above
for easy to understand tips and strategies on how to go paperless.



Free eReport When You
Subscribe To My Newsletter
The Bookkeeper's Notes

eBook cover



Subscribe To
The Bookkeeper's Notes
A Free Newsletter
For The Work From Home Business Owner

Email

Name

Then

Don't worry -- your e-mail address is totally secure. I promise to use it only to send you The Bookkeeper's Notes.



Brian Tracy's

Click here to receive Brian Tracy's Free Goal Setting Success Guide!




(Listed Under Websites NOT Under Local Business. This website is not associated with any business operating in Bonnyville Alberta.)



From the Mail Bag
Visitor Comments



Thanks for the information. It is nice to see there is an online site where I can go get answers to my bookkeeping questions. It was really a stroke of luck I came across this site. I googled my bookkeeping question to see if I could get an answer, a shot in the dark, and bookkeeping-essentials was one of the results listed. I looked over some other sites but none were as flexible as this site. I got a quick response and I will be using this site in the future. Thanks again.

Bayside, NY, United States



I love your site...its very homey!!! It's like reading/talking to a friend!! Thanks!!

Kim, Jackson, MS United States



Your website is positively BRILLIANT! I don't care at all for the numbers side of my business, but you've made it interesting, fun, comfortable--downright enjoyable! Bite-sized WELL WRITTEN bits walking me through fundamentals, encouraging me, explaining.(Note: "well written" covers everything from "interesting" to "intelligent." The reader doesn't stumble over elementary grammar errors, lots of typos, etc.) I've only just discovered this lovely gold mine!

Cherie, U.S.



I have just come across your site and it's great...thank you so much for the time it must take you to compile the data and information. I have no accountancy or book keeping knowledge and am currently trying to learn QuickBooks via YouTube. (lol) There must be an easier way as I don't have the time or finances, what with starting a new business, to attend a course at college or similar.

Debbie, Vancouver, BC Canada



As a novice at the bookkeeping game, this site has become my go to site for research. Thank you for the great resource. I do my data entry one or twice a year (very low volume) and I find I need retraining on Quickbooks for things like depreciation/CCA.

Den, St. Albert, AB Canada



A More Than FANTASTIC site! So often I've thought about putting something together like your site, but didn't have the time. Googling information about Supplies or Tools over under $500.00 was the most useful Google search I've ever done because of discovering your site. Way to go and THANKS VERY MUCH. PS.... Also loved it that you put the Tax chart for GST HST back to 1997; I spent hours trying to get this information from the CRA website. I've not had time to look at your whole site, but I will be refering to it often I'm sure and will mention anything I think is missing, should I not discover information as I might be looking for it. Thanks, Again

Leona, Sicamous, BC Canada



Thank you for your comprehensive reply to my question. I really appreciate the time you took to explain it to me.

Connie, Canada



This is an absolutely awesome site! I am not lying. I went to Chapters to try to find something just like this and they did not have what I was looking for - which your site does ... which is good definitions and explanations. I am going to book mark this page if that's okay. ... Great job and thank you. I will definitely use this resource.

PK Lethbridge, Alberta



My biggest problem in doing my books is keeping debits & credits straight in liability and equity accounts. I really liked the cheat sheet. (I think that will help me keep the debits and credits straight.)

Lisa, Williston, USA



Lake you're awesome in every way. I have had some insight about how to properly classify some accounts.

Karim, Calgary, Alberta



Thank you so much for this website. I am interviewing for my first bookkeeping position in over 10 years--and my first in Canada. I have AAS degrees in Accounting and Business Admin from the US but have never worked in "my field" since immigrating in 2000. Your website makes me feel more confident I can actually do the job I am interviewing for. So far, I have been refreshing my knowledge and preparing for a job interview. I've bookmarked the site for WHEN I get the job!

Robin, Toronto, ON



I love your website. Just love it.

Carolann
CPB Bookkeeping, Inc.
"The Organizer"
Lake Worth, FL



I posted a question on Accumulated Surplus and you asked me to comment on your comments. I really appreciated reading what you posted and it did help. Especially the part of talking to the accountant. That really makes sense. I find more and more that I interact with the accountants to keep on learning. Love Love Love your website. Just discovered it about 3 weeks ago and have been on it lots since then.

Jan
Red Deer, Alberta



Wow. I'm so thankful to have stumbled across your site, with the assistance of Google. :) I love your style of writing, your approach, and your message. Thank you for your time and efforts. In a nutshell, your light humor and simple approach is refreshing and uplifting.

Kathy, Hillsdale, United States



Your site is great by the way. I just came across it.

Trish, Canada



Thanks for responding so quickly ... I really appreciate all the forum help ... I do Love the forum and have looked through other questions on it and feel it will greatly help in the future. Your site is fantastic and I will recommend it to anyone asking about bookkeeping help.

Cindy, Calgary, Canada



It (your site) is very helpful and thank you for your tips and advice. I am so glad I found your site.

Lee, Calgary, Alberta



Thank you so much for your hard work on your site ... I find I learn quicker and easier with you than I did with courses. Your site has helped my knowledge, learning new things and with the explanation of terms/items. Keep up the good "BookWORK"!

Naomi, Balance Your Books, Squamish, B.C.



This website has been very helpful. It's been too many years since school and I'm a bit rusty.

Sue, Medicine Hat, Alberta



I just found this site tonight. It's going to help me a lot as I learn how to use my Quickbooks more fully (I've only used it for payroll). Don't ask me how I've managed to keep the books this long -5 years- without knowing much more than how to balance a checkbook. I'm getting some help from a professional now, but your site will keep my pro costs down. Thank you. I will definitely donate once I begin to use it with my QuickBooks. It's [your site] easier to understand than Help in QuickBooks. QuickBooks assumes I know bookkeeping concepts. It [your site] appears to be very thorough, though I've only scratched the surface of what I can learn. I took an online bookkeeping class a couple of years ago, but this site has direct application to quickbooks and it's a searchable site!

Ruth, Dos Palos, CA USA



Thank you for providing valuable information regarding home business taxes on this website.

U.C., Toronto, Canada



I started my own bookkeeping business two years ago and enjoy your site. I literally grab my cup of coffee and look around for hours. :D It's a wonderful site with loads of information and I'm all about learning from my peers who might have the answers to some of the questions I may have. Keep up the good work. :)

Tania, TaniasBookkeeping.org
Taking the worry away
Belledune, New Brunswick



BTW, did you say Bookkeeping? Cuz I fell asleep... just kidding!

Dr. Julia
www.advice-with-dr-julia.com

(I love her humour!)



Absolutely a great site! I have often dreamed of having a similar site but figured I might have to wait until I retire to get the time. I have bookmarked this site and will return again.

C.H.
Alwyn Enterprises
Scarborough , Ontario



You have a wonderful website. Thank you so much for letting me know you have one now. [It] is really well done and very, very informative. Also really charming.

R.P.
Reliable Recordkeeping
Toronto, Ontario



I'm enjoying reading your blog! Thought I'd drop you a quick note of encouragement.

Loralee, Red2Black.ca
QuickBooks "one
on one" coaching
Edmonton, Alberta



This is a marvelous site and one that I would like to use as the basis for training bookkeepers. I am a CPA here in the states and am in the process of building a what will hopefully become a substantial bookkeeping business (not a dark wood & gold lettered CPA firm). I want to serve the small business owner with the day to day service they need. You have obviously put in an enormous amount of time and effort here (there is no doubt there) and provide a wealth of fantastic information.

R. Keith Pierce, CPA, P.A.
I'll Sweat The Small Stuff For You - JaxTaxPro.com
Jacksonville, Florida