What Bookkeeping Do I Need To Do as a Self-Employed Copywriter or Freelancer?

What Bookkeeping Do I Need To Do as a Self-Employed Copywriter or Freelancer?

As a self-employed freelancer, especially if you’re not yet registered for GST, chances are your bookkeeping is not going to be all that complicated.

For starters, unless you are selling physical products, you won’t need to worry about keeping track of inventory, or working out the cost of products sold.

But you will still need to keep certain financial records and report these to the ATO at tax time.

Here are the main items you need to track.

Bookkeeping for the self-employed: income & expenses

You will need to keep a record of all business income and expenses and retain any related documents for 5 years.

Income: refers to your sales – i.e. the amount you get paid for your services, before any tax or deductions.

Expenses: these are your operating costs. Some examples might be website costs, marketing, stationery, software, insurance, legal costs, mentoring, and training. Deducting valid business expenses from your income reduces the amount of income tax you have to pay to the ATO.

What about income I haven’t yet received?

If you’re like many freelancers, you provide services to your client, issue them with an invoice, and then get paid after the event. How quickly you get paid will probably be down to the type of industry, your agreements with clients, or how you structure your services.

In my own case – I’ve worked for many years as a freelance writer of copy and web content. I know how slow the payments for writing services can be! This seems to be a pattern in the industry – at least from what I’ve heard anyway.

If this happens to you it means you need to keep track of invoices you’ve issued, including which ones have been paid and which haven’t.

There’s another issue to consider here as well. This is whether to report your income to the ATO based on invoices issued or on income received. In my case I do the latter.

If you report on work done and invoices issued, you would be using an accrual-based method of accounting. If on the other hand you report based on invoices paid (income received) your method would be cash-based accounting.

Since at times I have been waiting for many months for payments, for me the cash-based approach is more realistic.

But either way is fine as long as you are consistent and can back everything up with documentation.

How to record your transactions

There are a couple of options here. For example, you could hire a bookkeeper, or use a software subscription service such as XERO to record everything.

Since my bookkeeping is pretty simple I don’t bother with either. Instead, I record everything on spreadsheets. This has worked really well for me for years, and as they say – if it ain’t broke, don’t fix it!

In fact, I’ve found spreadsheets so handy I created one specifically for freelancers (or in fact any service business) that is not registered for GST. It comes with loads of instructions, and it is really simple to use (well I think so!). It costs very little, only a few dollars, and you can keep using it year after year!

Here’s what it contains:

  • Dashboard – graphical summary of sales, expenses, and unpaid invoices for the year
  • Invoice generator – to create professional-looking invoices to send to clients
  • Sales sheet – to record all your invoices and payments
  • Old invoices sheet – to keep track of unpaid invoices from the previous financial year
  • Operating costs sheet – to record business expenses paid
  • Profit & Loss – report of all activity over the year, based on both accrual and cash-based methods
  • Home office costs sheet – to record expenses related to a home office (see next section)
  • Examples sheet – screenshots to help you in filling in the data entry sheets
  • Bookkeeping Q&A sheet – explaining bookkeeping basics for sole traders.

Check it out at the bookkeeping tool shop! 

Bookkeeping for small home business: other deductions

Home office

If you work from home, you will most likely be able to claim for ‘occupancy costs’. For this I personally use the ATO’s ‘fixed-rate method’. With the fixed-rate approach, you claim a certain amount per hour (52c in 2022) for use of a home office. This to me is easier than trying to work out actual costs for electricity use and so on!

The ATO has a calculator where you can plug in information and get an estimate of your claim. You will need to know the size of your workspace in sqm, and costs such as mortgage interest or rent, home insurance, rates, and land taxes. You will also need to know your hours of usage (which can be worked out from a pattern of use over a 4-week period).

My previous post has more information on claiming occupancy costs, as well as a link to the ATO’s calculator.

Motor vehicle costs

You may be able to claim some motor vehicle costs if you use your car in running your business (e.g. to buy resources or meet clients).

The ‘cents per km’ method is the easiest. With this method you track your kms travelled, and claim a set amount per km (72c in 2022).

Go here to download a FREE Excel spreadsheet for recording travel costs

Depreciation

If you use the fixed-rate method for a home office, you won’t be able to claim depreciation (decline in value) for office furniture. You will however be able to claim it for equipment, such as a computer and printer. In some cases though, a small business owner could be eligible for instant asset write-off. These are issues you should discuss with your accountant.

Recording GST – or not?

Until your business income reaches $75,000 per annum, you won’t have to register for GST or worry about GST records.

If your business looks like it might reach the threshold for the year, you will need to register and start charging and tracking GST.

To collect GST you must add 10% to your sales invoices, which you will then remit to the ATO when you do your BAS. But you can also claim back the GST portion of business expenses you’ve paid as well. So, you will need to keep track of GST paid – but it’s important here not to automatically claim 10% but to check the actual bill for the amount.

Both GST collected and GST paid are recorded on your BAS. While you can complete and lodge your own BAS, any person you pay to do it on your behalf must be a registered BAS Agent.

Other resources and info

Find free and low-cost DIY bookkeeping resources at the bookkeeping tool shop.

For more tips and ideas, check out my blog or get in contact here!

Note: the information above is for general purposes only and should not be taken as financial or taxation advice. For professional advice regarding your business’s taxation you should speak to a registered tax accountant. 

How Do I Do Bookkeeping in a Craft Business?

How Do I Do Bookkeeping in a Craft Business?

As a creative business owner, you may not want to think too much about (boring old) bookkeeping.

But the good news is you don’t have to (think about it too much that is!). You just need a good system.

In a very small business, not registered for GST, the main things to keep track of are income and expenses.

For example:

Income from –

  • Online sales
  • Markets and fairs
  • Sales to shops
  • Other income sources (e.g. affiliates)

And operating expenses, such as –

  • Website costs
  • Advertising and marketing
  • Insurance
  • Market and selling fees
  • Small tools
  • Stationery
  • Software costs

and so on.

Claiming for valid expenses in this way reduces your income for the year, and the amount of income tax you have to pay on it.

But what about materials?

Thing is, when it comes to purchasing materials you can only claim for those that you have used up in products that you have sold. This means you can’t just buy a heap of materials and claim these as an expense against your sales. Not yet anyway. Until the materials are used in products and you’ve sold them they are considered to be assets, not expenses.

The same applies if you buy and re-sell products – they are not treated as an expense until you’ve sold them.

Once you’ve sold products the materials or products used in them can be claimed as ‘cost of goods sold’ or COGS.

If you know the value of materials that went into making a product, that’s great. But if not there’s a pretty simple formula for calculating COGS for a period of time in a small sole trader business:

– Inventory value at the start, PLUS inventory purchased during the period, MINUS inventory value at the end = COGS

In traditional accounting, COGS is subtracted from income to calculate Gross Profit. Other expenses are then deducted from that to calculate Net Profit. So it goes like this:

– Sales MINUS COGS = Gross Proft, MINUS Expenses = Net Profit

This process only really needs to be done once a year at tax time. But you may like to do it at other times as well, to see how your profit is tracking.

This also means of course you need to know the value of items you have in stock. As long as you’ve kept receipts this shouldn’t be too hard to work out, although you may have to do some estimates (e.g. for materials measured by the metre). You should also include the value of unsold finished items in your stock take.

How should I do bookkeeping for a hand-made business?

Here are 3 ways:

  1. Pay someone to do all your bookkeeping (could be good, but might not be in your budget right now!)
  2. Use a software program. There are some excellent ones around (such as XERO) that you pay a monthly subscription for, or
  3. Record everything on spreadsheets – e.g. you could create your own, or download one that someone else has made.

And here’s some good news (well I think it’s good anyway!). Custom Cashbooks has a low-cost Excel spreadsheet designed especially for non-GST-reg crafters. It is very easy to use (just fill in the blanks) and it comes with full instructions and support. It only costs a few dollars, and you can even choose the price you want to pay!

The file comes with the following sheets:

  • Invoice generator – where you simply fill in the white areas to create downloadable invoices for customers
  • Dashboard – contains graphs showing your sales and costs for the year
  • Sales sheet – for recording all your item sales
  • Operating costs – to record business expenses
  • Inventory purchases – for entering materials purchases as you go
  • Product costing – to work out what it costs you to make your products
  • Stocktake sheet – to record inventory on hand and calculate its value
  • Summary sheet – auto-generated report showing sales, expenses, and COGS
  • Home office costs – for recording costs related to use of your home for business (see next section for more info)
  • Bookkeeping Q & A – explains general bookkeeping concepts
  • Example sheet – contains screenshots of completed data entry sheets to help you in filling them in.

Check it out from the shop here! 

But if the spreadsheet doesn’t have everything you want, I may be able to create a custom one for your business.

What else can I claim?

Home-based office or studio

You may also be able to claim for ‘occupancy costs’ if you run your business from your home. The easiest way is to use the ‘fixed-rate method’ where you claim a certain amount per hour (52c in 2022) for use of your home office.

The ATO has a calculator for this. To use it you will need to know the size of your workspace, and various costs such as mortgage interest or rent, rates, land taxes, and home insurance.

You will also need to know your hours of usage. But if you haven’t kept detailed records, don’t panic! A ‘pattern of use’ over a 4-week period will do.

So let’s say you work out you have worked approximately 25 hours per week in your home-based business, and you have taken two weeks off for the year: your hours of work would be 25 hours x 50 weeks = 1,250.

Go here to read more about claiming occupancy costs 

Motor vehicle costs

If you use your car in running your business (e.g. to travel to markets or to buy inventory), you should be able to claim some costs for fuel and vehicle wear and tear.

The simplest way is to use the ‘cents per km’ method, where you track your kms travelled and claim a certain amount per km (72c in 2022).

But as for home occupancy costs – if you haven’t kept a detailed log, you can go by a pattern of use over a few weeks instead.

Download a FREE Excel spreadsheet for recording travel costs here

Depreciation

If you own assets such as computers, machinery, or business vehicles, you should be able to claim their decline in value over several years. However, as a small business owner you could instead be eligible for instant asset write-off. These are issues you would need to discuss with your accountant at tax time.

What about the GST?

You don’t need to register for GST until your business reaches $75,000 income per annum. Until then you don’t need to worry about GST records at all.

Once you do register however, your bookkeeping does get more complicated.

For example, you will need to add 10% to your sales. So if an item sells for $20, it will now be $22, with $2 being the GST portion. You must keep track of all the GST you collect from your sales and remit it to the ATO.

But the good part of registering for GST is that you can claim back the GST portion of all your business costs. To do so you will need to keep a record of all GST paid on these costs – but do make sure to check the actual bill for the amount rather than just assuming it’s automatically 10%. This is important for accuracy as not everything is subject to GST.

You will need to enter the GST collected and GST paid on your BAS (usually done quarterly in a small business). You can complete and lodge your own BAS, but if you pay someone else to do it for you, they must be a registered BAS Agent.

Got questions? I’m here to help!

For free and low-cost DIY bookkeeping resources, check out the bookkeeping tool shop.

Or for more tips and ideas, take a look at my blog.

Then again, to get in contact, go here!

Note: anything written here regarding taxation is for general information only and should not be taken as advice. For professional advice regarding your business’s income tax you should speak to a registered tax accountant. For advice on the GST, speak to a registered BAS Agent. 

 

 

Small Home Business Deductions: Here’s What You Can Claim at Tax Time

Small Home Business Deductions: Here’s What You Can Claim at Tax Time

As a home-based business owner you can claim deductions for expenses that relate directly to your business, which in turn reduces the amount of tax you have to pay.

Here are some typical examples of claimable business expenses:

  • business insurance (e.g. Public Liability, Professional Indemnity)
  • office expenses (e.g. stationery, printer toner)
  • website hosting
  • marketing and advertising
  • market fees
  • legal costs (e.g. business name registration)
  • accounting and bookkeeping.

(Note: inventory is treated as an asset until it is sold. See further down).

The important things are that the costs relate directly to your business and that you keep the receipts (can be digital).

However, if a cost only partly relates to your business, you will need to work out the business portion and claim only that amount. So let’s say you use your printer for your business 60% of the time and the remaining 40% is for personal use. In that case, you would only claim 60% of printer expenses (e.g. toner, paper) as a business deduction.

But what about home office expenses? Can you claim for these as well?  Well yes you can, and it’s not as difficult as it might seem.

The tax office refers to these as ‘occupancy expenses’. There are a few ways you can claim them at tax time.

How to claim for home office expenses

1. Actual costs method

The actual costs method allows you to claim for additional costs you incur (e.g. for energy and cleaning) on top of your normal household bills.

To use this method you will need a record of your household bills for mortgage interest or rent, council rates, and home and contents insurance. You will also need to know the percentage of the house you use to run your business.

With this method you can also claim the portion of phone, internet and energy costs that relate to your business.

2. Fixed-rate method

The fixed-rate method is a simpler method than actual costs. With this method, you can claim an hourly amount (52c per hour in 2022) based on your pattern of use of the workspace. (The hourly rate is based on an average for household energy costs).

The information you need for this method includes:

  • the size of your workspace in sqm
  • hours of work usage (can be based on a typical pattern of use over a 4-week period)
  • home costs – such as mortgage interest or rent, council and water rates, land taxes, and home and contents insurance.

Since energy costs are factored in, you won’t be able to claim a deduction for these separately. You will however be able to claim any portion of phone and internet costs that relate to your business.

Download a free excel template for recording general expenses and occupancy costs here

3. Temporary shortcut method

This is a super-simple method that allows you to claim 80c per hour for working from home and will be available until 30th June 2022. While it has a higher per-hour rate than the regular fixed-rate method, you won’t be able to claim any other running expenses on top – such as energy use, phone and internet, and asset depreciation.

Find out more on this method here.

Which method should I use?

You can use any method that relates to your situation, provided it is reasonable and you can back it up if asked. If you’re not sure which one you can use the ATO’s calculators to test out scenarios:

Me personally? I prefer the fixed-rate method as it is easier than actual costs. Also, I don’t use the shortcut method as it is probably better suited to employees working from home (e.g. during COVID) than home-based businesses. In any case it’s only temporary – so you would have to revert to one of the other two methods afterwards.

Claiming depreciation

Home business owners may also be able to claim depreciation for the decline in value of assets, such as computers, machinery, office furniture, tools, and business vehicles.

This also depends on what method you used to calculate occupancy expenses, as follows:

  • Actual costs method – you will be able to claim depreciation for office furniture and equipment.
  • Fixed cost method – in this case decline in value for furniture is included in the hourly rate so you won’t be able to make a separate claim. However, you can claim separately for equipment.
  • Shortcut method – you won’t be able to claim any decline in value of assets at all if you use this method.

Your accountant will be able to help you work out how much depreciation you can claim on your return.

Claiming motor vehicle expenses

If you use your vehicle for business purposes or in your employment you may be able claim for travel costs. This includes travelling to meet clients, to do deliveries, or to pick up supplies.

There are two methods available:

1. Cents per km method

With the cents-per-km method, you can claim for kms travelled in relation to your work or business (72c per km in 2022), for up to 5,000 kms per year. (Note that travelling from home to a workplace and back is not usually included).

If you use this method you won’t be able to claim other vehicle running costs though – such as petrol, registration or repairs.

You will need to keep a record of your travel. To calculate your claim, multiply the kms travelled for work or business by the hourly rate.

Download a free excel template for recording work or business related travel kms

2. Logbook method

The logbook method is more complicated than cents-per-km. If you use this method you can claim actual costs related to your business or work – such as fuel, oil, and other expenses.

You will need to work out the business portion of your vehicle use. You will also need to keep receipts, and a detailed logbook with odometer readings for at least 12 continuous weeks.

Inventory / trading stock

If you run a product-based business and purchase inventory, the costs are not treated as claimable expenses until the products are sold. Once they are sold you will need to calculate your ‘cost of goods sold’ (COGS) expense.

In a micro sole-trader business working out COGS should be relatively simple. The general formula for this is as follows: value of inventory at the start of the period (e.g. for the financial year), plus purchases during the period, less value of inventory at the end.  In the books this figure is deducted from revenue to calculate Gross Profit.

Small businesses may also be eligible to use simplified stock trading rules where the stock values over the year can be estimated. Find out more here.

Resources for DIY bookkeeping

As well as the freebies mentioned in this post I have a number of low-cost spreadsheet templates available for sole-trader and micro-business DIY bookkeeping. This includes workbooks for copywriters, product resellers, crafters, workplace contractors and more. And the best part is you get to choose the price you want to pay!

All my products come with instructions and my full support. You can check out my shop here. Also feel free to get in touch with me at tess@customcashbooks.com.au.

Note that all the information in this post is for general purposes only and shouldn’t be taken as advice. For taxation advice related to your situation, speak to a registered tax agent.

 

 

 

Which Bookkeeping Spreadsheet Template Would Best Suit My Business?

Which Bookkeeping Spreadsheet Template Would Best Suit My Business?

Custom Cashbooks offers a range of bookkeeping spreadsheet templates for self-employed people. Find out how to choose the one that best suits your needs.

Many small sole traders and freelancers may not realise it’s possible to do their own bookkeeping using Excel templates. It won’t suit every situation of course, but in many cases it’s certainly very possible!

To make it easier I’ve developed a range of excel bookkeeping templates specifically for sole traders, micro-businesses, contractors and freelancers. The best bookkeeping template for you depends on the needs of your business and what matters most to you. The following list of scenarios should go a long way towards helping you decide.

1. You’ve just started out and want a simple way to record transactions

In this case the ‘One Page Cashbook’ might be best for you. As the name implies with this cashbook you enter all your sales, expenses and other financial transactions on one page. It also generates a pie chart breakdown of costs, as well as cash flow and preliminary profit and loss figures.

The One Page Cashbook could be perfect for freelancers, home-based businesses, and small sole traders. And the best thing is it costs next to nothing!

OnePage example sheet

One Page Cashbook example page

2. You resell products and want to analyse your sales data

The Product Sellers template may suit you. It provides reports and graphs for sales-by-product (both quantity and $value) and costs breakdown, a profit & loss report, and sheets for calculating Cost of Sales and for stock counts and valuations.

Sales by product summary

Sales by product report and graphs

3. You’ve been ’employed’ at work as a contractor

Have you been employed in a job only to be told you need to work as a contractor and supply invoices? This trend is happening more and more in our economy.

If you’ve never kept accounts before this situation can be a bit daunting. So guest what – surprise surprise – I’ve created a spreadsheet just for that! It comes with invoice generator, income sheet, expenses sheet, summary report, and a travel diary. And best of all it only costs a few bucks!

Report summary

Employed contractor income and expenses report

4. You sell products that you make yourself

In any product-based business, you need to be able to calculate the cost to you of any products you have sold to customers (called ‘cost of goods sold’).

And guess what – I’ve created a spreadsheet for that, and more! The craft business cashbook comes with an invoice generator and sheets for recording sales, expenses, inventory purchases, stocktakes, product costings, and costs related to a home office or studio. Full instructions included!

Dashboard screen with graphs

Craft business cashbook – dashboard

5. You’ve been asked for a balance sheet

It kind of beggars belief when you’re a self-employed freelancer or a contractor in your job and some organisation or other asks you for financial reports and a balance sheet!  But the fact is that when you are self-employed you are viewed by banks and government organisations as a ‘business owner’, whether you particularly feel like one or not.

To help with this I’ve created a balance sheet template where you only need to fill in the blanks. And it costs only a dollar or two to buy!

Balance Sheet image

Balance Sheet template

6. You need an easy way to keep track of unpaid sales or bills

While most of my templates are designed for businesses that operate on a cash basis (that is, recording sales and costs as they are paid) I realise there may be some businesses that need to keep track of sales or bills before they’ve been paid.

So I’ve created two products for these situations – the Accounts Receivable and Accounts Payable templates. The first allows you to enter sales and payments and monitor what is and isn’t paid, and what is current and what is overdue for each customer. The second works in a similar way but for bills that you owe to suppliers.

They are both really easy to use and like all my products come with detailed instructions and support.

Accnts Receivable Summary

Accounts Receivable summary report

7. You need to generate nice-looking invoices and/or credit notes for customers

These days you have to provide quite a bit of information on your business invoices. So I’ve made sure to cover that with my standalone Invoice and Credit Note Template.

The template comes with tax code options and the ability to switch between invoices and credit notes with one click. You also have the option of changing the colours, adding your own logo and more. Check it out here.

(Note that some of the other templates contain a similar invoice generator a well).

Tax Invoice template

Tax Invoice example

8. You just need an easy way to record stocktakes

The stocktake sheet is really simple to use. It has spaces for entering stock details, minimum levels, stock counts and actions to be taken. And when a product is below the minimum acceptable level you will be triggered to reorder.

It also comes with a pricing sheet where you can test out % markups and calculate selling prices. And best of all it costs about as much as a cup of coffee!

(Note that the product sellers template also contains a similar stocktake sheet).

Inventory sheet

Stocktake sheet example

9. You want to create a product price list

For this you could use the inventory stocktake template mentioned above (no. 8) as it contains a worksheet for entering markup percentages to set prices for your products. You could use it to test out different pricing scenarios.

Pricing sheet image

Product pricing worksheet

10. You’re a freelance copywriter and need a convenient way to record transactions

I’m a copywriter of many years myself so I personally know the score here! The copywriter’s cashbook has an invoice generator, sheets for entering invoices, payments and expenses, and it also generates reports and graphs.

So for one low price you can record everything on the one template – you just need to fill in the blanks. It could also be useful for other types of freelancers. Check it out here.

Dashboard screen with graphs

Freelancer/copywriter dashboard page

11. You need a cashbook that lets you do bank reconciliations

If one of your top priorities is ensuring that you capture every transaction that goes through your bank account, the Cashbook with Bank Rec template could be just what you need!

It allows you to enter all your transactions, classify them according to sales, expenses or other items, and indicate if they are on the current month’s bank statement. It also produces a cash flow report and a summary report and graphs of sales and expenses. Here’s the link.

Bank rec charts

Bank rec cashbook summary page

12. You need a really easy way to record just about everything

Now we come to my biggest product! The full bookkeeping workbook contains an invoice generator as well as sheets for sales, costs, asset purchases, cost of sales, sales projections, and a variety of graphs and reports – e.g. P&L, activity report, cash flow, and balance sheet.

I spent months developing this bookkeeping spreadsheet template so I’ve tried to think of everything – or at least as much as possible!

Full bookkeeping workbook dashboard

Still not sure?

If so send me a message so I can help you decide! And don’t forget all these bookkeeping excel templates come with my full support and help using them if you need it. But if none of the products suits you exactly I may be able to create something more customised for you. Get in touch.

 

 

Could I, Would I, Should I Do My Own Bookkeeping?

Could I, Would I, Should I Do My Own Bookkeeping?

When you’re flying solo it’s quite possible to save money by doing your own bookkeeping on Excel templates. Find out how!

Whether you’re just starting out as a sole trader or freelancer or you’ve been at it for a while, you might be wondering if you can manage your own accounts on top of everything else. Well, the short answer is yes – in many cases it’s very doable if you go about it the right way!

Here are 3 very good reasons for DIY bookkeeping, as well as an outline of the pitfalls and tips on how to go about it safely.

The benefits of DIY bookkeeping

1. Save money

By doing your own bookkeeping – at least as much as possible – you can save a lot on the expense of hiring a bookkeeper. You may still need to hire a bookkeeper or BAS Agent from time to time for specific tasks you are not sure of or can’t do yourself, but if you can get the bulk of the tasks done yourself it’s going to cost you way less than otherwise.

Another issue is that getting your books in order by EOFY (End of Financial Year) is going to cost you a lot less at your accountant’s office come tax time! Accountants usually charge considerably more than bookkeepers so if you turn up at their office with a box of receipts and little in the way of records, you can expect a pretty hefty bill!

One way to do your own bookkeeping is by paying a monthly subscription for a software tool, such as XERO or MYOB. These (and others) are excellent tools but if you run a relatively simple business it’s quite possible to do most of your bookkeeping tasks using Excel spreadsheets.

2. It’s really not that hard!

While bookkeeping can at times get very complicated and involved and require a skilled operator, a lot of it is fairly routine. For example, it doesn’t require any special skills to record a sale, expense, or bank account entry!

Also, for a small sole trader or contractor with a relatively straightforward business, it’s really just a matter of knowing a few basics and having a system in place, and preferably of having some support when and if you need it.

3. You will be in control

Some business owners are very hands-off when it comes to their financial affairs. They would rather just hand it over to someone else to manage as they feel they have enough on their plate, thanks very much.

But if you are the type that wants to be involved and to know what’s going on, and to have more control, DIY bookkeeping is a great way to go about it.

The potential pitfalls

Now we get to the what-can-go-wrong bit!

The biggest risk is that of errors, which can arise from recording items incorrectly or not setting up accounts right in the first place. The latter can also result in compounding mistakes over time, fines from the tax office, or even a higher risk of ATO audits.

These things can happen whether you use a software subscription such as XERO, or you use spreadsheets to record transactions or use a manual system.

So read on to discover how you can minimise the risks of DIY bookkeeping.

How to manage DIY-bookkeeping safely

So, how do you go about doing your own bookkeeping?

As already mentioned there are some excellent bookkeeping software tools around these days. Many of them are quite intuitive to use and come with training videos and articles. However, most of these require a monthly subscription which can really add up over time, and you may only need a fraction of their features anyway.

Another way is to set up your own spreadsheets if you feel confident and have the time. You could have different sheet tabs for different purposes – say, one for sales, another for expenses, another for budgets and so on.

Problem - solution imageBut what if you don’t have the time, or money, or the inclination to do either of those? In that case, there is another way – that of using preformatted templates designed by an experienced bookkeeper. That’s why I’m offering bookkeeping spreadsheet templates at a very low cost from my website. These come complete with instructions, and with support if you have any questions or are not sure how to use them.

My products include a full excel bookkeeping workbook and a range of other sole trader bookkeeping spreadsheets where all you need to do is fill in the blanks! Most of them come with auto-generated reports and graphs as well. You also get the option of choosing your own price into the bargain.

Check out the options for bookkeeping on Excel templates

Feel free to check out my shop page to see what I have on offer, or get in touch by email or online message.

 

.