sjd password

[stek]

Google excel password cracker?

[Jeebo72]

does anyone know the password to unprotect the free SJD bookkeeping software 2010 spreadsheet?

Yes, cos I've got the software to break MS passwords. It's amazing how simple it actually is

[Jeebo72]

Try:

sjd

.

Too many letters / characters!

[Clippy]

OK, to be serious, I have now downloaded the spreadsheet as my year end is approaching and this thread prompted me to do it now.

I've been able to edit it - changed company name etc.

Is this what you mean or are you referring to other privileges?

[hgllgh]

I do

hmmmm ... probably asking too much to get a straight answer to a straight question on here. The reason I ask is because the VAT calculation is wrong. Up to the cut off date it should be 15% not 17.5% ... thats poor accounting

[Jeebo72]

hmmmm ... probably asking too much to get a straight answer to a straight question on here. The reason I ask is because the VAT calculation is wrong. Up to the cut off date it should be 15% not 17.5% ... thats poor accounting

I just sent mine to the account manager and asked them to sort. They did.

Are you actually using them? If so get them to do the work you're paying for!

[pjclarke]

I submitted mine, spotted soon after that the rate was wrong for some months, rang them up to inform them, and was told they had already applied the correction.

BTW - I have a spreadsheet that I use alongside the SJD one for analysis. The main benefit is a little macro that pulls invoice, banking, and cash transactions out of the one-tab-per-month format that SJD use into a single transaction list. I can then use the magic of Excel's auto-filter function to find individual transactions or classes of transaction, and I have built a few pivot tables off the list that shows me income and outgoings by class, calendar and company year. I really should get out more.

I developed it to build a single master list of transactions once I had several years worth accumulated across multiple SJD spreadsheets, as searching across tabs and worksheets for a particular transaction was a PITA. Its also been useful for MI type functions, looking at trends, spotting data entry errors etc.

For example, I specify a 'batch' that new cash expenses should go into as they are imported from the SJD sheet. About once a month I filter the transaction list by batch number and total the amount so I know how much to reimburse from the ltd account. Simples!

It's not 'production quality', by any means, just a tool for my own use, but if anyone thinks this could be useful, I'll upload a copy - shorn of data - to a public place.

[simondolan]

hmmmm ... probably asking too much to get a straight answer to a straight question on here. The reason I ask is because the VAT calculation is wrong. Up to the cut off date it should be 15% not 17.5% ... thats poor accounting

We password protect to make sure that clients don't accidently change/delete the formulae.

As Jeebo72 said, if you are a client of ours please send it over and we'll change it for you. In fact, even if you're not, send it over to me and I'll do it for you.

[Clippy]

I submitted mine, spotted soon after that the rate was wrong for some months, rang them up to inform them, and was told they had already applied the correction.

BTW - I have a spreadsheet that I use alongside the SJD one for analysis. The main benefit is a little macro that pulls invoice, banking, and cash transactions out of the one-tab-per-month format that SJD use into a single transaction list. I can then use the magic of Excel's auto-filter function to find individual transactions or classes of transaction, and I have built a few pivot tables off the list that shows me income and outgoings by class, calendar and company year. I really should get out more.

I developed it to build a single master list of transactions once I had several years worth accumulated across multiple SJD spreadsheets, as searching across tabs and worksheets for a particular transaction was a PITA. Its also been useful for MI type functions, looking at trends, spotting data entry errors etc.

For example, I specify a 'batch' that new cash expenses should go into as they are imported from the SJD sheet. About once a month I filter the transaction list by batch number and total the amount so I know how much to reimburse from the ltd account. Simples!

It's not 'production quality', by any means, just a tool for my own use, but if anyone thinks this could be useful, I'll upload a copy - shorn of data - to a public place.

How very kind.

Yes please.

[The Wikir Man]

Try:

sjdsjd
sjdsjdsjd

Can't think of any more.

Doesn't that get you into TPD? Or is that 'jdjdsjd'?