Reply to: SJD Spreadsheet

[MyUserName]

Just email them. I have never waiting more than a day for a reply from them on a query. More than once they just had me send them the spread sheet and worked it out themselves.

[Danielsjdaccountancy]

I don't really bother with it either but a quick mail to my accountant asking him to change carry overs and jobs done. Not hard really.

Yep - please do email us, we're more than happy to explain this and/or help work out the number you are looking for.

[northernladuk]

How do you do that?

This has always annoyed me too. I never bothered much with the estimated remaining field for this reason.

I don't really bother with it either but a quick mail to my accountant asking him to change carry overs and jobs done. Not hard really.

[VectraMan]

- unhide the 'Accountant Calculations' worksheet.

How do you do that?

This has always annoyed me too. I never bothered much with the estimated remaining field for this reason.

[GB9]

SJD spreadsheet = reason I left SJD......it sucks

[Northern Soul]

You mean - you asked them...???

It'll never catch on.

I encountered the same question re. SJD spreadsheet myself....i.e., how do you account for a dividend drawn against retained profit from a previous year(s) without the s/sheet then reducing your accrued dividend entitlement for the current year.

The answer, as best as I can ascertain, is to

- unhide the 'Accountant Calculations' worksheet.
- row 54 heads a 'balances bought forward' section
- enter your 'Max Dividends Remaining Est." from previous year-end into the corresponding field

This amount is then added to the Max Remaining estimate for current year, as displayed at the top of teh Summary worksheet.

You can thus book a dividend payment and the Summary worksheet will calculate a correct overall amount of remaining dividend entitlement for the company inclusive of all previous years, alongside those being accrued for the current financial year.

As an aside, appears you can do similar for any expenses accrued in a previous year that need to be retrospectively booked in the current year. In my case, my accountant identified some retrospective expenses in my year-end accounts preparation that I thus need to book in this years accounts to ensure my bank balance still reconciles.

Try it and you'll get the point better than i can explain here.

cheers,
Gareth

[malvolio]

I queried sjd about this last year as I was in the same position.
I emailed the sheet and they updated it with a new field to take into account outstanding dividends

You mean - you asked them...???

It'll never catch on.

[brasi12345]

answer

I queried sjd about this last year as I was in the same position.
I emailed the sheet and they updated it with a new field to take into account outstanding dividends

[ribble]

Yes but the directors loan account will show a positive amount when in fact i'm actually settling it...and also the dividend summary will show a negative value. I understand that the years should be kept seperate, in this case is there a way to adjust the bank account balance without have any effect on the new year calculations?

Dan

[Gonzo]

How do I account for taking a divi to pay back the outstanding loan for last comapnies year then?

The journal entry will show a debit in the dividend column and a credit in the directors loan account column and will have no impact on the bank account.

[ribble]

How do I account for taking a divi to pay back the outstanding loan for last comapnies year then?

[Green Mango]

I agree.

The spreadsheet is being used for bookkeeping so should only refer to current events. The only figure to bring forward is the bank account balance so that you can reconcile the bank statements.

Thats right. On the month 1 sheet at the top there is an "Opening Balance Current Account" for the bank otherwise I brought nothing forward on my SJD spreadsheet.

[Gonzo]

No idea what SJD sheets do obvously as not sure how sjd treats the data but would have thought better to bring nothing forward. That way you can check for balance over the year, and add previous carried forward years figures only when it is correct.

I agree.

The spreadsheet is being used for bookkeeping so should only refer to current events. The only figure to bring forward is the bank account balance so that you can reconcile the bank statements.

[xoggoth]

No idea what SJD sheets do obvously as not sure how sjd treats the data but would have thought better to bring nothing forward. That way you can check for balance over the year, and add previous carried forward years figures only when it is correct.

[malvolio]

No idea but I'm guessing it's because the dividend belongs to the financial year in which it was declared, as far as the accounts are concerned, not when you decide to pay it.

I've never really seen the need for a dividend estimator either, TBH. I have a pretty good idea of my running profit and keep within that.