Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Accounts for Sole Trader

  • 26-08-2012 7:44pm
    #1
    Registered Users, Registered Users 2 Posts: 300 ✭✭


    Hello,

    I am PAYE and have just set up a sole trader business on the side.

    What can I and cant I include in my accounts as expenses.
    • Advertising expenses.
    • Internet marketing.
    • Meals out
    • Mobile phone bills although not all calls would be for my sole trader business.
    • If I was planning on purchasing a car could I put this down as an expense as I will need it for the sole trader business (Remember I am also PAYE)
    Is there a general sole trader accounts template available on the internet?

    All advice appreciated.

    Regards
    Paul


«1

Comments

  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Advertising expenses - yes

    Internet marketing - yes

    Meals out - no

    Mobile phone bills although not all calls would be for my sole trader business - yes. If you have a package deal you can claim the full amount as a business expense.

    If I was planning on purchasing a car could I put this down as an expense as I will need it for the sole trader business (Remember I am also PAYE) - You can claim up to €23,000 against a car purchase and up to 85% of motor expenses if you also use it as a private vehicle.

    All expenses that you incur in the running of your business are allowable. Except a portion of your rent/mortgage if you work from home - that is not allowed. You can however claim a portion of your heat/electric. Don't forget your Internet provision.

    I have an accounts template you're looking for. PM me your email address and I'll send it to you.


  • Registered Users, Registered Users 2 Posts: 7,157 ✭✭✭srsly78


    Meals out - no

    Corporate entertainment - yes. This is no problem for a limited company, and I don't see why a sole trader would be treated differently.

    Note names of all attending should be recorded.

    A limited company can also expense a portion of rent for home office. I do not see why a sole trader would be treated differently, this is a legitimate business expense. Mortgage no, rent yes.

    OP it is worth paying an accountant for proper advice. Much better than asking randomers on the internet. Expenses are hugely important for an self-employed person.


  • Registered Users, Registered Users 2 Posts: 300 ✭✭smeharg


    srsly78 wrote: »
    Corporate entertainment - yes. This is no problem for a limited company, and I don't see why a sole trader would be treated differently.

    ...

    Client entertainment is not allowable - for limited companies or sole-traders.


  • Registered Users, Registered Users 2 Posts: 3,442 ✭✭✭phormium


    Was just reading this question as am also interested in answer, I know the advice is always given to talk to an accountant. Sometimes though it can be better to get many answers to see if they all agree. I have spoken to 3 different accountants about similar, accounts for a very basic sole trader business, got different information from all 3, in the end I decided to ring Revenue and ask them some questions to try and get the definitive answer. Interestingly Revenue said 2 of the accountants while giving differing answers to the same question were both kind of right, Revenue said Accountant 1 gave me the correct rule but Accountant 2 gave me what was actually done in practice.

    Gloomtastic - any chance I could get a copy of that template too, please?


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    phormium wrote: »
    Gloomtastic - any chance I could get a copy of that template too, please?

    If you haven't already done so, please PM your email address.


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 7,157 ✭✭✭srsly78


    smeharg wrote: »
    Client entertainment is not allowable - for limited companies or sole-traders.

    Entertainment for employees = allowed. Christmas party = allowed. Beers on friday = allowed.

    Also see here: http://www.revenue.ie/en/about/foi/s16/income-tax-capital-gains-tax-corporation-tax/part-05/05-03-02.pdf?download=true

    "Payments which are no more than the reimbursement of vouched expenses actually incurred wholly, exclusively and necessarily in the performance of the director's or employee's duties are not normally treated as emoluments (Paragraph 4.4 of Employer's Guide to PAYE). The same treatment should be applied to payments in respect of the reimbursement of vouched entertainment expenses."


  • Registered Users, Registered Users 2 Posts: 300 ✭✭smeharg


    srsly78 wrote: »
    Entertainment for employees = allowed. Christmas party = allowed. Beers on friday = allowed.

    Also see here: http://www.revenue.ie/en/about/foi/s16/income-tax-capital-gains-tax-corporation-tax/part-05/05-03-02.pdf?download=true

    "Payments which are no more than the reimbursement of vouched expenses actually incurred wholly, exclusively and necessarily in the performance of the director's or employee's duties are not normally treated as emoluments (Paragraph 4.4 of Employer's Guide to PAYE). The same treatment should be applied to payments in respect of the reimbursement of vouched entertainment expenses."

    Not sure what point you're trying to make but client entertainment is never allowed and sole-traders aren't employees.


  • Registered Users, Registered Users 2 Posts: 1,853 ✭✭✭Glenbhoy


    srsly78 wrote: »
    Corporate entertainment - yes. This is no problem for a limited company, and I don't see why a sole trader would be treated differently.

    Note names of all attending should be recorded.

    A limited company can also expense a portion of rent for home office. I do not see why a sole trader would be treated differently, this is a legitimate business expense. Mortgage no, rent yes.

    OP it is worth paying an accountant for proper advice. Much better than asking randomers on the internet. Expenses are hugely important for an self-employed person.

    If you own your own property you will be liable to CGT on the office part of the property if you sell it at a profit (apparently it used to happen).


  • Closed Accounts Posts: 878 ✭✭✭rainbowdash


    smeharg wrote: »
    Not sure what point you're trying to make but client entertainment is never allowed and sole-traders aren't employees.

    But of course if you gave the local rugby club €3000 to place an advertisement on their notice board and an envelope pops through your letterbox with an advertising receipt along with 10 international match tickets with admission to the pre match function then that would just be a coincidence!


  • Registered Users, Registered Users 2 Posts: 416 ✭✭thecelt


    Gloomtastic - any chance I could also get a copy of that template too, thanks?


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    thecelt wrote: »
    Gloomtastic - any chance I could also get a copy of that template too, thanks?

    Please PM me your email address.....


  • Registered Users, Registered Users 2 Posts: 250 ✭✭aidan.connolly


    Hi, If you purchase a car for the business, you have to capitalise it and then you can calim deprecation over 8 years ( 12.5% per year ) .
    I dont think you can claim it all in the first year.

    I would suggest, as others have suggested, have a chat with an accountant and remove any doubt.

    You should be also aware that for the purposes of your taxes, both your PAYE and "sole trader" income are combined to reach your taxabe earnings. If you are currenlty using all your Allowances for your PAYE income, you should expect a high tax hit on your profits of your Sole Trader business.

    Best advice. See an Accountant.

    Aidan


  • Registered Users, Registered Users 2 Posts: 1 Howtodo


    Advertising expenses - yes

    Internet marketing - yes

    Meals out - no

    Mobile phone bills although not all calls would be for my sole trader business - yes. If you have a package deal you can claim the full amount as a business expense.

    If I was planning on purchasing a car could I put this down as an expense as I will need it for the sole trader business (Remember I am also PAYE) - You can claim up to €23,000 against a car purchase and up to 85% of motor expenses if you also use it as a private vehicle.

    All expenses that you incur in the running of your business are allowable. Except a portion of your rent/mortgage if you work from home - that is not allowed. You can however claim a portion of your heat/electric. Don't forget your Internet provision.

    I have an accounts template you're looking for. PM me your email address and I'll send it to you.

    Hi
    Like the other person I am PAYE and a sole trader, I downloaded a software package for €14.99 but am not sure where I enter business expenses, do they come under purchases? My business is very simple, just a service with no actual purchases just expenses. I would appreciate it ifyou could also send me that software template please?
    So you cant claim a portion of mortgage interest if you work from home?
    Thanks


  • Registered Users, Registered Users 2 Posts: 1 papamac


    Hi Gloomtastic,

    Would you mind giving me a copy of that accounts template.

    Thanking you

    papamac


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    papamac wrote: »
    Hi Gloomtastic,

    Would you mind giving me a copy of that accounts template.

    Thanking you

    papamac

    I need your email address papamac. Please pm me.


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Hey

    For any of you guys in the Southeast i can recommend an good accountant who does accounts for 500 to 600e and Vat returns for 50e.

    Pm if you like their contact details

    When you say accounts for €500 to €600, do you mean tax returns? I used to be charged this by my accountant before I discovered I could file them myself online for nothing!


  • Registered Users, Registered Users 2 Posts: 4,686 ✭✭✭barneystinson


    Hey

    For any of you guys in the Southeast i can recommend an good accountant who does accounts for 500 to 600e and Vat returns for 50e.

    Pm if you like their contact details

    When you say accounts for €500 to €600, do you mean tax returns? I used to be charged this by my accountant before I discovered I could file them myself online for nothing!

    I presume she means accounts and tax returns. You must do your own accounts as well as your tax return so?

    I'm not being smart but unless you're either much more clued in than the average sole trader you've probably made mistakes that could cost you more money in the long run than you're saving yourself by doing a DIY job.

    Also, how do you get approval for finance/overdraft from your bank; they tend to be pretty sticky about stuff like accounts certified by the accountant etc...?

    Do you adjust the trade profit for disallowable expenses? Do you add back depreciation and claim capital allowances? Do you retain a schedule of the tax written down value of your fixed assets, and calculate balancing allowances or charges on disposals of vehicles/equipment? Do you properly accrue for prepayments and accruals, trade debtors and trade creditors, do you fully reconcile your bank account? Do you properly account for leases/Hire purchases, and do the necessary adjustments to the adjusted profit computation when a rebate of rentals occurs (and ditto on your vat return)? If you do all that, then fair play to ya, and particularly if you can do it in an amount of time shorter than it would take you to earn 500 quid to pay an accountant.

    A good accountant always adds value and pays for themselves in the long run. And if you are good at what you do, your time is generally better spent earning money doing that than slaving through your accounts and tax return. Just like you wouldn't try to plumb your own house just because plumbers are a bit expensive...


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Hey

    For any of you guys in the Southeast i can recommend an good accountant who does accounts for 500 to 600e and Vat returns for 50e.

    Pm if you like their contact details

    When you say accounts for €500 to €600, do you mean tax returns? I used to be charged this by my accountant before I discovered I could file them myself online for nothing!

    I presume she means accounts and tax returns. You must do your own accounts as well as your tax return so?

    I'm not being smart but unless you're either much more clued in than the average sole trader you've probably made mistakes that could cost you more money in the long run than you're saving yourself by doing a DIY job.

    Also, how do you get approval for finance/overdraft from your bank; they tend to be pretty sticky about stuff like accounts certified by the accountant etc...?

    Do you adjust the trade profit for disallowable expenses? Do you add back depreciation and claim capital allowances? Do you retain a schedule of the tax written down value of your fixed assets, and calculate balancing allowances or charges on disposals of vehicles/equipment? Do you properly accrue for prepayments and accruals, trade debtors and trade creditors, do you fully reconcile your bank account? Do you properly account for leases/Hire purchases, and do the necessary adjustments to the adjusted profit computation when a rebate of rentals occurs (and ditto on your vat return)? If you do all that, then fair play to ya, and particularly if you can do it in an amount of time shorter than it would take you to earn 500 quid to pay an accountant.

    A good accountant always adds value and pays for themselves in the long run. And if you are good at what you do, your time is generally better spent earning money doing that than slaving through your accounts and tax return. Just like you wouldn't try to plumb your own house just because plumbers are a bit expensive...

    Funny, none of my accountants ever mentioned any of those services. They just filed my tax return to the revenue (I had to fill in their template) and charged me €500 for the pleasure.

    Everything else I do myself. It's not rocket science and all you need is a bit of knowledge in the workings of a Spreadsheet.


  • Registered Users, Registered Users 2 Posts: 4,686 ✭✭✭barneystinson


    Funny, none of my accountants ever mentioned any of those services. They just filed my tax return to the revenue (I had to fill in their template) and charged me €500 for the pleasure.

    Are you VAT registered? And you're telling me you didn't receive from any of these people a set of accounts i.e. an accountant's report, a P&L and a balance sheet? In order to generate a proper set of accounts some/all of those "services", that you say were never mentioned to you, have to happen.

    It's like walking into a chipper and ordering a bag of chips - they don't tell you "we're going to chop up some potato then put it into hot oil and cook it for a few minutes..."; in the same way an accountant shouldn't need to explain to you the exact steps they need to follow to produce your accounts, but there should/will be a number of steps.

    And you never answered my question about the banks, I'd be very interested to hear if/how you get facilities from a bank without accountant certified accounts...

    You may also have missed a key phrase in my post - "good accountant" - like most trades / professions there are plenty of bad ones, who'll overcharge you and not provide a service. But my point remains, a good accountant will always pay for themselves, particularly if your ambition is to grow or expand your business into a bigger operation, or when you get a Revenue audit.
    Everything else I do myself. It's not rocket science and all you need is a bit of knowledge in the workings of a Spreadsheet.

    So, by this do you mean that you don't do any of the things I listed in my previous post, because if you don't then you've just implied that you clearly do need an accountant... ;)


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Funny, none of my accountants ever mentioned any of those services. They just filed my tax return to the revenue (I had to fill in their template) and charged me €500 for the pleasure.

    Are you VAT registered? And you're telling me you didn't receive from any of these people a set of accounts i.e. an accountant's report, a P&L and a balance sheet? In order to generate a proper set of accounts some/all of those "services", that you say were never mentioned to you, have to happen.

    Not VAT registered anymore but when I was, I used to file my own returns. As for P&L/balance sheets/accounts etc, I produce my own. I have been in business for eighteen-odd years and know my way around an accounts department. It should also be noted that I started my business career in the UK where processes are everything.

    I have supplied an Excel template to a couple of dozen sole traders here on Boards and elsewhere. It comprises a P&L balance worksheet, an income worksheet, an out goings worksheet and an invoice template. Everything a sole trader needs as far as accounts are concerned. Have had no negative feedback from anyone yet. As I said, it's not rocket science, it's just about following procedures.

    As for a bank loan, I follow my late father's no. 1 rule after 65 years in business - never a lender or a borrower be. If you don't have the cash, don't spend it. Something this country would do well to follow.


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 4,686 ✭✭✭barneystinson


    Funny, none of my accountants ever mentioned any of those services. They just filed my tax return to the revenue (I had to fill in their template) and charged me €500 for the pleasure.

    Are you VAT registered? And you're telling me you didn't receive from any of these people a set of accounts i.e. an accountant's report, a P&L and a balance sheet? In order to generate a proper set of accounts some/all of those "services", that you say were never mentioned to you, have to happen.

    Not VAT registered anymore but when I was, I used to file my own returns. As for P&L/balance sheets/accounts etc, I produce my own. I have been in business for eighteen-odd years and know my way around an accounts department. It should also be noted that I started my business career in the UK where processes are everything.

    I have supplied an Excel template to a couple of dozen sole traders here on Boards and elsewhere. It comprises a P&L balance worksheet, an income worksheet, an out goings worksheet and an invoice template. Everything a sole trader needs as far as accounts are concerned. Have had no negative feedback from anyone yet. As I said, it's not rocket science, it's just about following procedures.

    As for a bank loan, I follow my late father's no. 1 rule after 65 years in business - never a lender or a borrower be. If you don't have the cash, don't spend it. Something this country would do well to follow.

    Ah that explains a bit then, and if you're operating at a level below VAT threshhold (which is really a micro-business) then it may be simple enough. However, as I said if you wanted to expand your business and required bank finance I think you might get a nasty surprise.

    If you're supplying this template to other people I hope it's all right; could be case of the blind leading the blind otherwise...

    Actually, based on your description of it, it doesn't appear to involve double entry bookkeeping, nor does it produce a balance sheet. Do you prepare a debtors control account or creditors control account? Or opening/closing stock calculations? And have you ever had a revenue audit, and if so were they satisfied with your records?


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Ah that explains a bit then, and if you're operating at a level below VAT threshhold (which is really a micro-business) then it may be simple enough. However, as I said if you wanted to expand your business and required bank finance I think you might get a nasty surprise.

    If you're supplying this template to other people I hope it's all right; could be case of the blind leading the blind otherwise...

    Actually, based on your description of it, it doesn't appear to involve double entry bookkeeping, nor does it produce a balance sheet. Do you prepare a debtors control account or creditors control account? Or opening/closing stock calculations? And have you ever had a revenue audit, and if so were they satisfied with your records?

    You must be a whizz at dinner parties Barney! ;)

    I run a business that sells a service to consumers and businesses that include some of the largest corporations in the world. I don't need double entry whatsits, I get paid on the day or else I'm sticking to you like glue until I do get paid, any creditors are paid on invoice.

    My business, and my accounts template, have been used as a case study by Smurfit Business School and they found no blind spots.

    If revenue wanted an audit in the morning they'd find my accounts as tight as a knat's ass.

    If I needed money to expand, I don't believe my bank would have any issues with my accounts either. Who were Anglo Irish Bank's auditors again?

    Business is simple - give the customer what they want plus some, get your money in on time and keep your suppliers happy. I do all of the above very well. It might be a micro business, as you call it, but it suits me and my family 100%. I also know I could transfer my knowledge to any other business and make it work just as well.

    Bloody Professionals, I've never been disappointed with how useless they really are! :)


  • Registered Users, Registered Users 2 Posts: 4,686 ✭✭✭barneystinson


    Ah that explains a bit then, and if you're operating at a level below VAT threshhold (which is really a micro-business) then it may be simple enough. However, as I said if you wanted to expand your business and required bank finance I think you might get a nasty surprise.

    If you're supplying this template to other people I hope it's all right; could be case of the blind leading the blind otherwise...

    Actually, based on your description of it, it doesn't appear to involve double entry bookkeeping, nor does it produce a balance sheet. Do you prepare a debtors control account or creditors control account? Or opening/closing stock calculations? And have you ever had a revenue audit, and if so were they satisfied with your records?

    You must be a whizz at dinner parties Barney! ;)

    I run a business that sells a service to consumers and businesses that include some of the largest corporations in the world. I don't need double entry whatsits, I get paid on the day or else I'm sticking to you like glue until I do get paid, any creditors are paid on invoice.

    My business, and my accounts template, have been used as a case study by Smurfit Business School and they found no blind spots.

    If revenue wanted an audit in the morning they'd find my accounts as tight as a knat's ass.

    If I needed money to expand, I don't believe my bank would have any issues with my accounts either. Who were Anglo Irish Bank's auditors again?

    Business is simple - give the customer what they want plus some, get your money in on time and keep your suppliers happy. I do all of the above very well. It might be a micro business, as you call it, but it suits me and my family 100%. I also know I could transfer my knowledge to any other business and make it work just as well.

    Bloody Professionals, I've never been disappointed with how useless they really are! :)

    Kudos to you, but the above post illustrates how you are the exception rather than the rule, so my concerns about the suitability of your approach for other traders remain.

    If you aren't VAT registered you can't be selling much of this service.

    And do dinner parties still happen?!


  • Registered Users, Registered Users 2 Posts: 326 ✭✭Attabear


    I don't need double entry whatsits,

    And with that, the entire accounting profession was dismissed.:)


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    Attabear wrote: »
    I don't need double entry whatsits,

    And with that, the entire accounting profession was dismissed.:)

    Amen to that! :)


  • Registered Users, Registered Users 2 Posts: 204 ✭✭gccrowley1


    Advertising expenses - yes

    Internet marketing - yes

    Meals out - no

    Mobile phone bills although not all calls would be for my sole trader business - yes. If you have a package deal you can claim the full amount as a business expense.

    If I was planning on purchasing a car could I put this down as an expense as I will need it for the sole trader business (Remember I am also PAYE) - You can claim up to €23,000 against a car purchase and up to 85% of motor expenses if you also use it as a private vehicle.

    All expenses that you incur in the running of your business are allowable. Except a portion of your rent/mortgage if you work from home - that is not allowed. You can however claim a portion of your heat/electric. Don't forget your Internet provision.

    I have an accounts template you're looking for. PM me your email address and I'll send it to you.



    Just wondering could you also pm me the template.......

    Cheers


  • Registered Users, Registered Users 2 Posts: 223 ✭✭07734


    Would love the template too, thanks
    07734


  • Registered Users, Registered Users 2 Posts: 7,140 ✭✭✭ebbsy


    Go get a proper accountant. Oh and if ye had a revenue audit in the morning you would need one.


  • Registered Users, Registered Users 2 Posts: 204 ✭✭gccrowley1


    ebbsy wrote: »
    Go get a proper accountant. Oh and if ye had a revenue audit in the morning you would need one.


    Probably will but I have literally just setup and cash is hard enough to come by without paying for an accountant , I just want rough idea of what to keep a track of and if I have a spreadsheet with this template filled with all details then would it not be a bit easier for me and the accountant to organise...I just like to be able to see easily any income and outgoings and expenses at home but don't know how to layout......


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 5,358 ✭✭✭borderlinemeath


    Hi Gloomtastic, just sent you a pm for a copy of your template, thanks a mil.


  • Registered Users, Registered Users 2 Posts: 204 ✭✭gccrowley1


    gccrowley1 wrote: »
    Advertising expenses - yes

    Internet marketing - yes

    Meals out - no

    Mobile phone bills although not all calls would be for my sole trader business - yes. If you have a package deal you can claim the full amount as a business expense.

    If I was planning on purchasing a car could I put this down as an expense as I will need it for the sole trader business (Remember I am also PAYE) - You can claim up to €23,000 against a car purchase and up to 85% of motor expenses if you also use it as a private vehicle.

    All expenses that you incur in the running of your business are allowable. Except a portion of your rent/mortgage if you work from home - that is not allowed. You can however claim a portion of your heat/electric. Don't forget your Internet provision.

    I have an accounts template you're looking for. PM me your email address and I'll send it to you.



    Just wondering could you also pm me the template.......

    Cheers


    Got that....... Thanks a lot ......appreciate it.


  • Registered Users, Registered Users 2 Posts: 1 gerryos


    I am in the same boat aa PAYE and just startng out as a sole trader n the side. I would appericat it if you might send the template you refered to on. my e mail is gpfoto@ymal.com Many thnaks


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    gerryos wrote: »
    I am in the same boat aa PAYE and just startng out as a sole trader n the side. I would appericat it if you might send the template you refered to on. my e mail is [EMAIL="gpfoto@ymal.com"]gpfoto@ymal.com[/EMAIL] Many thnaks

    The email I sent you came bouncing back so I changed it to 'ymail' and resent. If you haven't received it please pm me your correct email address.

    In an update, it turns out my sparring partner Barneystinson actually works for the Revenue. He's had a copy of the template for a good few months now and I've heard nothing untowards back. :)


  • Closed Accounts Posts: 5,943 ✭✭✭smcgiff


    Would genuinely like to see it too, pm to follow - will give my honest opinion.


  • Closed Accounts Posts: 5,943 ✭✭✭smcgiff


    Thanks for that Gloomtastic,

    It's certainly a useful template. It would be most suitable for a small business. It will benefit your accountant to have this, as he can use it as a starting point. You've also given good advice re the splitting of Revenue streams.

    There are a couple of flaws/improvements that could be made, imho.

    Depreciation

    In your example there's a cost of equipment of €500 in January ( I know this is only an example). If this were the full cost of the equipment it would be wrong to include here. For accounting purposes it should be* the estimated monthly charge for the use of the item.

    Depreciation is important as it allows you to cost the inclusiveness of the asset, yet not overly burden an accounting period with its full cost when it will be used for more than one accounting period.

    Depreciation could be calculated in a separate sheet and the total for Depreciation included in your monthly/annual accounts.

    Depreciation will also need to be included in your adjusted profit calculation, by adding back. Capital allowances would then need to be deducted as per Revenue rules.


    *Accountants, please forgive the use of language!

    Overly relying on a template.

    Not a problem for you I'd imagine, but others that use the sheet will need to modify for changes in the VAT rate.

    I know it wasn't designed for other users, other than yourself, but it should be pointed out that the expense lines on the template are not exhaustive (I know this is going to come across as obvious!)

    Extra column for Coding

    It'd help end of year calculations if you added an extra column on your outgoings sheet, so that the expenses were identified as you went along i.e. enter telephone, advertising etc. At the end of the year you could simply use a sumif etc function to total up the various expenses. These then could be linked to what you call your cashflow sheet (it'd be best to call this an I&E or Income and Expenditure sheet - cashflow is entirely different and not related to profit)

    Lack of Balance Sheet

    This actually might be a fatal flaw in your template. The Revenue now expect to know what your bank balance is at the end of your accounting period, plus to know what your drawings are. The drawings figure will not be obvious from your workings. And as such would subject the user to a greater risk of audit.

    In summary,

    A useful template, but I'd have to come up short in actually recommending its use without the input of an accountant (neither does gloomtastic as far as I can see). Now, it could be levelled at me that I would say that, seeing as I'm an accounting moderator.

    However, I've not worked in practice in over 10 years and would have no benefit for advising such.

    So, useful, but not perfect :)


  • Advertisement
  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    smcgiff wrote: »
    Thanks for that Gloomtastic,

    It's certainly a useful template. It would be most suitable for a small business. It will benefit your accountant to have this, as he can use it as a starting point. You've also given good advice re the splitting of Revenue streams.

    There are a couple of flaws/improvements that could be made, imho.

    Depreciation

    In your example there's a cost of equipment of €500 in January ( I know this is only an example). If this were the full cost of the equipment it would be wrong to include here. For accounting purposes it should be* the estimated monthly charge for the use of the item.

    Depreciation is important as it allows you to cost the inclusiveness of the asset, yet not overly burden an accounting period with its full cost when it will be used for more than one accounting period.

    Depreciation could be calculated in a separate sheet and the total for Depreciation included in your monthly/annual accounts.

    Depreciation will also need to be included in your adjusted profit calculation, by adding back. Capital allowances would then need to be deducted as per Revenue rules.


    *Accountants, please forgive the use of language!

    Overly relying on a template.

    Not a problem for you I'd imagine, but others that use the sheet will need to modify for changes in the VAT rate.

    I know it wasn't designed for other users, other than yourself, but it should be pointed out that the expense lines on the template are not exhaustive (I know this is going to come across as obvious!)

    Extra column for Coding

    It'd help end of year calculations if you added an extra column on your outgoings sheet, so that the expenses were identified as you went along i.e. enter telephone, advertising etc. At the end of the year you could simply use a sumif etc function to total up the various expenses. These then could be linked to what you call your cashflow sheet (it'd be best to call this an I&E or Income and Expenditure sheet - cashflow is entirely different and not related to profit)

    Lack of Balance Sheet

    This actually might be a fatal flaw in your template. The Revenue now expect to know what your bank balance is at the end of your accounting period, plus to know what your drawings are. The drawings figure will not be obvious from your workings. And as such would subject the user to a greater risk of audit.

    In summary,

    A useful template, but I'd have to come up short in actually recommending its use without the input of an accountant (neither does gloomtastic as far as I can see). Now, it could be levelled at me that I would say that, seeing as I'm an accounting moderator.

    However, I've not worked in practice in over 10 years and would have no benefit for advising such.

    So, useful, but not perfect :)

    Thanks for the feedback.

    It is a small business template but I have used it in larger businesses (€2m+) for monthly management accounts.

    Good point re Coding. I currenty use the Sort function to identify all the outgoings for the year end but I'll check out the sumif function.

    I did include a balance originally, at the bottom of each month, but after a year or so got rid of it because it bore no resemblance to reality - I use my sole trader account to treat my family to a meal out every now and then when business is good. :) I might stick it back in for others sake.

    I stopped using an accountant a couple of years ago when business dropped significantly and I couldn't justify, or afford, spending €500+ on year end tax returns. Discovering you could do it yourself online in 20 minutes was indeed a revelation! It will take a lot of reassurance to ever use one again in future I'm afraid.

    If it makes the accounting profession feel better about itself, I stopped using lawyers many, many years ago and do all that side myself as well! ;)


  • Banned (with Prison Access) Posts: 3,571 ✭✭✭newmug


    Hi Gloomtastic! Could I please get a copy of your template aswell? I sent you a PM:)


  • Registered Users, Registered Users 2 Posts: 190 ✭✭gerryR


    Many thanks for the template Gloomtastic, just wondering for someone not VAT registered is it just a case of removing the VAT columns to make the spreadsheet valid or would there be different calculations required for non-VAT registered people?

    Thanks again!


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    gerryR wrote: »
    Many thanks for the template Gloomtastic, just wondering for someone not VAT registered is it just a case of removing the VAT columns to make the spreadsheet valid or would there be different calculations required for non-VAT registered people?

    Thanks again!

    Just delete them.....


  • Registered Users, Registered Users 2 Posts: 56 ✭✭karlkarlson


    i've also PM'd you Gloomtastic if you don't mind sending it on again. Thanks, Karl


  • Advertisement
  • Banned (with Prison Access) Posts: 1,065 ✭✭✭leonidas83


    Would it possible to claim expenses for trips abroad concerning your expenses & how detailed would these need to be?
    e.g. going to Scandanivia to look at office spaces for the expansion of your business


  • Registered Users, Registered Users 2 Posts: 7,157 ✭✭✭srsly78


    Yes but you are much better off operating as a limited company if you are doing lots of travel. Can claim flat-rate expenses then as per revenue guidelines.


  • Registered Users, Registered Users 2 Posts: 5 geenzeys


    Dear Gloomtastic,
    You seem to have identified a need with that accounts template!
    Any chance I could have one too??


  • Registered Users, Registered Users 2 Posts: 9,052 ✭✭✭Gloomtastic!


    geenzeys wrote: »
    Dear Gloomtastic,
    You seem to have identified a need with that accounts template!
    Any chance I could have one too??

    Sent!

    Get a couple of requests a week. Can't believe there's nothing else out there but I'm happy to help! :)


  • Registered Users, Registered Users 2 Posts: 5 geenzeys


    much appreciated :) This will save me hours of work!


  • Closed Accounts Posts: 2,091 ✭✭✭Peterdalkey


    Good on you Gloomster "The Simon Community of Accounting Packages!!


  • Registered Users, Registered Users 2 Posts: 42 Farm King


    Hi Gloomtastic! Could I please get a copy of your template aswell? I sent you a PM


  • Registered Users, Registered Users 2 Posts: 1,807 ✭✭✭Poly


    Just starting out myself, Id really like a copy if it's not too much trouble.
    many thanks


  • Registered Users, Registered Users 2 Posts: 1,807 ✭✭✭Poly


    Thanks for that Gloom
    I owe you a pint if we meet up.

    Best regards
    Poly


  • Registered Users, Registered Users 2 Posts: 42 Farm King


    Thanks Gloomtastic!


  • Advertisement
Advertisement