The Book-keepers Forum (BKF)

Post Info TOPIC: Journals in Quickbooks


Expert

Status: Offline
Posts: 1991
Date:
Journals in Quickbooks
Permalink Closed


Hi folks.

I have some journal entries to do and one of them is posting an amount to ' Accounts payable' the accountant has given me a breakdown of the entries, there are 2 suppliers.  Do I post these as a supplier invoice first? Sorry I am abit confused by this one.  Not come across this one before on QB's.

If you are a sage user, it will be the same process, so if you know it in Sage by all means post it on here as I work with both.

Kind regards,

 



__________________

Amanda



Senior Member

Status: Offline
Posts: 266
Date:
Permalink Closed

Yes, you'd need to post the adjustments as supplier invoices (or credit notes, if appropriate). 



__________________

Pearce & Co - Chartered Accountant and Chartered Tax Adviser 

www.pearceandcoaccountants.co.uk

These comments are outline only and are not a substitute for specific professional advice.



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Hi Amanda

I usually post the journal to "sundry creditors" or a suspense account, and then I post invoices to this account, to clear the balances.

__________________


Expert

Status: Offline
Posts: 1991
Date:
Permalink Closed

Hi Everyone,

Thanks for the info, lastly if it says opening balances would you post them on the first day of the new year? I am assuming so normally they say but this one didn't.

Many thanks,



__________________

Amanda



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

I usually post 31.03.13 year end journals as 01.04.13, Doing this keeps the 31.03.13 figures to match the original TB that the accountant worked on, and the accountant will be able to pick up on any changes (it happens) and allows them to check you posted your journals correctly, when you send them the 31.03.14 general ledger.

__________________


Expert

Status: Offline
Posts: 1991
Date:
Permalink Closed

Thanks Michelle,

I thought that was the case, although I have one accountant who gets me to post them on the last day, which is confusing, but he's always insistent on this so that what I do for that one only.

Many thanks,



__________________

Amanda



Senior Member

Status: Offline
Posts: 245
Date:
Permalink Closed

Hi Amanda

This is a common problem but it is my opinion that opening balance journals should be done on the last day of the financial year so 31.03.13... not 01.04.13

This is because when you run the bfwd TB it will match the final accounts and be the starting point for the new year.

If you don't the figures will form part of the transactions for the financial year and not be in the comparative figures.

The sanity check that the journals are posted correctly is always done on the opening P&L reserves which wont be right if you post on the 1st day of the new year.

A good accountant will have the record of the original TB given, the adjustments made and then the final TB so you wont need to worry about "Doing this keeps the 31.03.13 figures to match the original TB that the accountant worked on" (sorry michelle)

Hope that helps

Cheers

Jeremy

__________________

"Quite simply the best add on for Sage we have ever invested in.."

Want to see what all the fuss is about? Click here: OptegraMRP



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Ugh, no, pet hate! Last day of the last year, not first day of the next!

If your software allows you to run a brought forward trial balance report, posting those journals as the last day of the closed year means that report should agree with the final closing trial balance - if it doesn't, you know there's a problem. You don't get that if you post as the first day of the new year, without manually working it out - and introducing another opportunity for a mistake*. It also means the year is entirely self contained.

* I've seen more than my fair share of year end adjustments posted on the first day of the next year with mistakes made. I've also seen cases where that has happened, and the people who had done it realised they made mistakes so fixed them... except they didn't, merely believed they had done so, and had actually made matters worse.

Michelle: Those changes (they do indeed happen) can still be spotted using the correct date, as well as the incorrect date you suggest using! :p



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Expert

Status: Offline
Posts: 1991
Date:
Permalink Closed

How funny is that, all but one of the accountants get me to post on the 1st of the new year and the one I mentioned above is the only one who gets me to do it on the last day of the previous yr.

__________________

Amanda



Senior Member

Status: Offline
Posts: 245
Date:
Permalink Closed

Dare I say it.......??

All but one of those accountants just don't understand.... (or don't care?)

There.. I said it..

It is right to post it on the last day of the financial year.... Please don't post on the 1st day of the new year - it causes so much more unnecessary work.

Anyone else with me, or shall I get my coat ?





__________________

"Quite simply the best add on for Sage we have ever invested in.."

Want to see what all the fuss is about? Click here: OptegraMRP



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

I have worked in 3 practices over 20 years, and its been the norm. If an audit was being done, the first thing you check is that the opening balances on the new year's general ledger match the closing software TB on file. Plus, most of the time, the year end has been run by the time the journals are given. Ultimately, it doesn't really matter as long as the system is right, but this is the way everyone I know does it. And my clients that come in from other accountants have the same situation.

I might also add that we only provide balance sheet journals - the balancing figure of which goes to the profit and loss account (3200 on sage) to match that to the final accounts prepared on accounts production software.  The only time a journal hits the P&L is when its a prepayment or accrual reversal or some adjustment that needs to effect the current year P&L (and I always give this as a second journal, to be posted after the year end journals have been posted, as it again keeps things very clear).

Also, when posting the bookkeeping TB into the accounts production software, some codes will get posted together (think 10 purchase codes posted as one figure in the accounts, think other creditors, think postage and stationery, think all the VAT accounts in Sage) so the accountants final TB doesn't match the bookkeeping software code for code.  So when the client inadvertently creates a prior year adjustment, we use their original TB to spot the difference, rather than having to unpick all the accounts production codes - this saves time in trying to discover which code has the error in it, and so saves the client fees.  Indeed some clients have hundreds of codes, so it can get messy.

Its true some clients do like every journal posting into the P&L on 31.03.13 but I have only met one in my entire career.  "one accountant who gets me to post them on the last day, which is confusing, but he's always insistent on this so that what I do for that one only." This is how most clients feel, and the client comes first, not the accountant, not the software bods.

I think the other thing to consider is that there are accountants out there, who don't actually have a good knowledge of every bookkeeping system on the market, indeed a fair few were still using written ledgers to prepare accounts until the introduction of IXBRL a few years back.  For me, if something goes wrong on Sage, I can find it pretty quickly, using that original balance as a guide... but in Quickbooks, it just takes me forever.  So using this system, keeps things a little simpler across the board.   It negates one step in the identifying process - one which can be a very big step on a large system.

 



-- Edited by FoxAccountancyServices on Thursday 13th of June 2013 08:51:49 AM

__________________


Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Vince.. There is no right and wrong way. There is only the way that fits the client and accountant, who work together to keep everything straight. What is the point in doing something that neither are used to or understand? Amanda gets confused, I get confused, so then the 31.03.13 date is the problem.

Any accountant who isn't supporting the client with issues - the problem is with their service, not with the date.



-- Edited by FoxAccountancyServices on Thursday 13th of June 2013 09:27:05 AM

__________________


Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Hi Jeremy

As stated, there is no wrong or right way. I have used this system for 15 years (first 5 years were doing sh*t detail!), as have many other accountants I know, and everybody has been happy, no issues, client gets it, I get it. Nobody has been hurt, nobody has been confused, the HMRC and Companies House accounts have been correct. So it cant be *wrong*, it is just *one way* of doing things.

That's not to say doing things your way would not have produced the same result, its just *another way* of doing things. You might notice that instead of attacking your way, I have only defended my own, as well as defended the client who gets confused when things that don't NEED to be changed, are forced upon them by someone's difference in opinion.

My way is one my clients are happy with, one we can fix very quickly in the event of issues because we both understand it. If a client came to me who used your way, I would happily continue with that... the only time there is confusion is when someone comes along and starts trying to change something that aint broke. If the client is happy and the system is correct, it doesnt really matters which way it gets done. Its completely acceptable to go with preference.



-- Edited by FoxAccountancyServices on Thursday 13th of June 2013 10:14:27 AM

__________________


Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

* I've seen more than my fair share of year end adjustments posted on the first day of the next year with mistakes made. I've also seen cases where that has happened, and the people who had done it realised they made mistakes so fixed them... except they didn't, merely believed they had done so, and had actually made matters worse.

Morning Vince.. usually, I check the opening balance agrees to the original TB, if not, I know its not the journal that created the problem.

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Jeremy: My coat is apparently the one next to yours. It looks like I may have started my original reply just as you were finishing yours.

Amanda (and Michelle, quoted and emphasised that): That one accountant who confuses you by asking you to post the journals on the last day of year is the one who gets it right - all the others get it wrong.

Michelle: Just because it's the norm doesn't make it right. You actually sum up the reason for this in your third paragraph: "...there are accountants out there, who don't actually have a good knowledge of every bookkeeping system on the market..." - that is indeed why so many suggest using (or use themselves) the first day of the new year. (And make other mistakes).

While I can understand the reasons you give, the logic behind them is equally applicable to situations where the journals have been posted on the last day of the year, just with a slight adjustment in your thinking and processes.



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 245
Date:
Permalink Closed

Hi Vince

Yep - hope we are not in the minority....

It just creates more reconciliation work than is required. The clients bfwd balances agreeing to the final years accounts is the check you should be doing. Any discrepancies can be identified straight away.

Posting them on day one of the new year will mean you will have to use the bfwd balance & then add the journals done to see if they agree to the prior yr accs - creating an unnecessary task if the journals were posted on day 1 of new year.

I was in practice 12 years as a qualified ACCA before I quit to start Optegra - so although now I am a software bod, I am a qualified accountant at the same time

I spent a lot of my time training my teams and colleagues the correct way to do it as they were following the previous norm - which was wrong. "Why did the auditor cross the road?" anyone

I cant think of any reason why posting this way would be right?

Good debate going on here...

Cheers

Jeremy





__________________

"Quite simply the best add on for Sage we have ever invested in.."

Want to see what all the fuss is about? Click here: OptegraMRP



Expert

Status: Offline
Posts: 1991
Date:
Permalink Closed

HI Everyone,

Sorry I didn't realise I was opening up a can of worms.

Good debate.

I just find it strange how some accountants I deal with like them on the last day of the old year and some like it on the 1st day of the new year. I suppose as long as I do what they say then I'm okay!
cheers



__________________

Amanda



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Hi Amanda

Its like anything, people have their own way of doing things. But wouldn't life be boring if we all were the same? :)



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About