Share this content

Quickbooks TB not agreeing to GL

Didn't find your answer?

I am preparing small limited company accounts for which the client has done the bookkeeping on Quickbooks Online. It turns out that some of the major P&L figures on the TB do not match the balances on the general ledger by many thousands. 
 

Has anybody else encountered similar issues with quickbooks and if so, how was it rectified? I have ensured the date ranges are identical for both reports. 
 

Any thoughts or ideas would be greatly appreciated. 
 

Thanks

Replies (6)

Please login or register to join the discussion.

Danny Kent
By Viciuno
01st Oct 2021 18:32

I don't use Quickbooks myself regularly so not come across this myself but only thing I can think of that would cause something like this would be if the general ledger you are running straddles the year end.

Thanks (0)
Scalloway Castle
By scalloway
01st Oct 2021 19:22

Check the the accruals basis is being used for both.

Thanks (0)
By petersaxton
02nd Oct 2021 10:23

Check what transactions make up the TB and GL accounts. Once you identify the differences then you should understand why?

Thanks (0)
avatar
By Paul Crowley
02nd Oct 2021 13:22

Both need to be printed at the same time
Not unusual
Everytime to date the client did one in the morning and the other in afternoon
Client did stuff between the two

Thanks (1)
Replying to Paul Crowley:
RLI
By lionofludesch
03rd Oct 2021 07:40

Paul Crowley wrote:

Both need to be printed at the same time
Not unusual
Everytime to date the client did one in the morning and the other in afternoon
Client did stuff between the two

[chuckle]

Thanks (0)
avatar
By the_fishmonger
04th Oct 2021 12:35

Despite the logic that you have entered from and to dates, the various developers of each part of software can (and do) use differing parameters. The individual with product oversight ought to be right on top of this but I doubt they recognise the troubles it causes.

In the case of the QB reports you mention, it does seem one report uses those from/to dates and the other uses accounting period settings set elsewhere in the system.

Aside from Sage, the old desktop software seemed okay with odd length reporting. But most of the cloud systems have adopted a 'they can only ever have 12 month accounting periods' and don't cope well as a result, giving differing figures on the various reports.

Maybe this is another moving the basis period type of thing which is to be imposed in the future...which we're not yet advised of!

Edit - I should point out that this is an issue we've had with both longer and shorter APs on QB/Sageone. There are workarounds on QB but Sage is utterly unco-operative

Thanks (0)
Share this content