FREE Bookkeeping Spreadsheet Template - Excel and Google Sheets

Подписаться 25 тыс.

Просмотров 52 тыс.

50% 1

To grab your copy of the new and improved EXCEL Template, click here: bit.ly/3X6yrJC
To grab a copy of the GOOGLE SHEETS template click on one of these links (improved version coming soon):
➜ Int Dates: bit.ly/45G8z8S
➜ US Dates: bit.ly/3rbWzNf
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Please note that Bullseyemoney is not a financial or tax adviser. Our videos are here to inform you and the information provided does not constitute financial, taxation, legal, business or other professional advice and should not be relied upon as such. Bullseyemoney is not liable or responsible for any financial, tax, legal, business or other decisions you make. If you are looking for advice, you should seek a suitable and qualified adviser.

Опубликовано:

5 сен 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 132

@4tun8nanette 5 месяцев назад

This is the best free spreadsheet available. You made it so easy to change the Category Names. Thanks so much!

@bradheck9630 3 месяца назад

Thank you so much for contacting me and helping me with my issue. Its so nice to find someone that really reads the comments and is there to help. thanks again. Brad

@LifeOftheOreste 6 дней назад

Thank you so much for taking the time and sharing this.

@axellecandleco 3 месяца назад

Can not thank you enough for this spreadsheet and the tutorial. I appreciate you so!

@QrooSpanish 3 месяца назад

Fantastic! Thank you for sharing the sheets and the info.

@margarethncube6194 6 месяцев назад

Thank you the template is easy to use.

@nannogray4412 Месяц назад

U save me, I was about to pay for Spreadsheet of this stuff but through this video I have learned that you can get it free thank U god bless

@junkeewear6014 4 месяца назад

Thank you so much for this tutorial, I am grateful to have it.

@mthozuma4637 3 месяца назад

This is so helpful thank you so much. Imagine running a restaurant not having the time for creating templates for book keeping also not having money to spend on these accounting softwares, it's all draining. This is good just add the actual costs and i think it can also be used for projections as it outlines everything from costs to profits.

@BeaWinterfeld 9 месяцев назад

Thank you so much, this looks do-able!

@kimleroux5538 5 месяцев назад

This is simple and efficient, thank you for sharing your knowledge and tools!

@TheBookkeepingChannel 5 месяцев назад

You're very welcome!

@IsabellG964 10 месяцев назад

Perfect, just what I needed. thanks

@TheBookkeepingChannel 10 месяцев назад

Glad it helped!

@kayv73 3 месяца назад

Thank you for the simple and easy explanation for the usage of the spreadsheets. So useful. =) 🙏

@user-yu4zj7ei2h 3 месяца назад

Thank you for sharing your knowledge. I was looking for examples of how to do this

@lifelatelywithizai 3 месяца назад

Thank you so much for creating this spreadsheet! It really helped me with my task. I appreciate what you do ❤️

@DELuke2008 4 месяца назад

this is great. thank you very much

@grahamallan9240 6 месяцев назад

Thank you so much. Your video helps me a lot. thank you 😀

@samuelagina1 3 месяца назад

Thanks this was extremely useful

@sdin3269 6 месяцев назад

thanks, this spreadsheet is very helpful

@misterman2442 8 месяцев назад

Thanks so much.

@leocabreramusic 2 месяца назад

Thank you very much for this!

@heyyyizme8993 6 месяцев назад

Thank you!!

@robertbobedokho4650 5 месяцев назад

Thanks alot. I really needed this for my start up

@TheBookkeepingChannel 5 месяцев назад

No problem!

@jeanpriol6416 2 месяца назад

Thank you!

@user-vl8zi4rt6c 6 месяцев назад

Thank you for the amazing video.

@TheBookkeepingChannel 6 месяцев назад

Glad you enjoyed it!

@walibaker7335 7 месяцев назад

Good Content Thanks

@davespurlock5694 6 месяцев назад

So helpful

@Islamic_Naat_And_Lectures 5 месяцев назад

wow, thanks a lot . God Bless you.......

@TheBookkeepingChannel 5 месяцев назад

Welcome!

@abdulbasit9364 3 месяца назад

❤tysm 😊

@user-zp6jr1fw4z 4 месяца назад

Thanks for a nice educational video.

@TheBookkeepingChannel 4 месяца назад

You are welcome

@lelagebeya 6 месяцев назад

thank you

@countermeasuresecurityengi9719 5 месяцев назад

well done easy peasy bro!

@TheBookkeepingChannel 5 месяцев назад

Thanks 👍

@hernandlumawig6579 7 месяцев назад

Thanks for sharing this great excel tool... Do you have a complete template having the 4 basic FS: BS, PL, STATEMENT OF CASH FLOW, STATEMENT IN CHANGE IN OWNER'S EQUITY?

@watchthevideos99221 4 месяца назад

Is it possible to add more expense categories'? Ten is not enough for my business.

@Karrmohamed1998 5 месяцев назад

Thanks 👍 very much bro

@TheBookkeepingChannel 5 месяцев назад

No problem 👍

@samuelagina1 3 месяца назад

Please how do I add more roles (E.g Sales Revenue) i want to add more like sales Revenue from Software, sales revenue from Affiliate commisions. Please how do I add more columns?

@upholdthesecond92 4 месяца назад

This is great! Works perfect. Would you be able to expand on this template to include a bank register, credit card transactions, inventory and a balance sheet? I think all of this information can be included in the transaction list and categorized accordingly. This would allow to track inventory, assets and liabilities. And, is it possible to add more lines to the transaction table above the 1000? Thanks a ton!!

@RaperiUnderground 3 месяца назад

would love also an answe on this question? also in the google sheet that i downloaded there are only 10 categury names for expenses! can we add more and how can we d o that? thank a lot!

@brandonlarsen03 2 месяца назад

Just setup my sheet! What would be an easy way to make a new page for each quarter and have it search for the certain dates in the quarter and insert it into the profit loss sheet just like you have but on a different page?

@sansfishing8859 3 месяца назад

Thank you very much for the spreadsheet. I've noticed an issue with the calculations. When I input a date range, the income statement is including transactions that fall outside of that range. Can you please help me with this one?

@hugal.official 6 месяцев назад

Thank you for the awesome video! The template is so simple and amazing. One question, how did you calculate the tax paid? is that something we have to do manually?

@TheBookkeepingChannel 5 месяцев назад

It's not a proper calc. I just put an example number in.

@TheDecoratingDivas 6 месяцев назад

This is so helpful. Just a couple of things - I can't get the date to work. Also some things came in as Income that were expenses. Like phone and postage? I fixed it by calling it something else but can't figure out what I did wrong. Version - Sheets Int dates (I am I UK)

@ronsimpson2150 5 месяцев назад

This looks great. It seems to work on Libre Office Calc. Hopefully no glitches arise. I actually want to use this for a simple home cashbook, and need more income categories, but can make do as it is. Thanks for sharing this with us.

@ronsimpson2150 5 месяцев назад

Ooops unfortunately it doesn't seem to work on Libre Office Calc once data is entered.. Back to the drawing board.

@TheBookkeepingChannel 5 месяцев назад

Hi there. I'm actually making some cashbook templates for home use. Is there anything in particlar you want in it?

@ronsimpson2150 5 месяцев назад

Thanks for your response. Soon I'll email you a few screenshots of the Windows app that I've been using. Now migrated to Linux but haven't been able to find anything suitable for Linux as yet. Gnu Cash is a bit more complex than I require. A very basic programme that I've been using for about 15 years or more. Cheers, Ron

@ronsimpson2150 5 месяцев назад

Very basic. Income, Expenses by category. keeping a running bank balance total, Reference and details columns, balance sheet. Monthly summary report, and also transaction report (audit tail) is what I currently have (had). Also nice to have is Balance sheet transfers in and out. Sorry can't find your email so didn't send screen shots. Cheers.

@TheBookkeepingChannel 4 месяца назад

@@ronsimpson2150 email address is on the channel detail page: bullseyemoney@outlook.com

@mbaraksaid9744 4 месяца назад

Nice and brilliant spreadsheet. But how do i check on reports for a different date range

@Islamic_Naat_And_Lectures 5 месяцев назад

please share more accounting templates like; journal, general ledger, trial balance, income statement, and balance sheet in one worksheet...as well as sales, purchasing, and expenses templates,,, thanks..

@hopefuture8686 5 месяцев назад

How can I record my sales if I sell different products, like Sales A, Sales B, Sales C ….., and see the total of each sales

@michaelboyd7993 3 месяца назад

I would love for you to show step by step how you built this? I am currently using this template but have issues with the date. It show's "red" even though it's correct.

@terripace5756 2 месяца назад

Thank you for this. How do you set the tax rate for the UK?

@TheBookkeepingChannel 2 месяца назад

If you email me (address is in my profile) I can give you a free copy of a UK template I've been working on that has VAT.

@juntosesbetter.758 8 месяцев назад

Mate thanks for the template is great only one question shall I enter the amounts groos or net? im asking for GST Purpose

@TheBookkeepingChannel 8 месяцев назад

The Income Statements (Profit & Loss Report) usually shows numbers net of GST.

@mdotson127 4 месяца назад

What about the running balance in the checkbook? I need a basic check register as well. Any ideas?

@phoneblaster Месяц назад

...hello there. When you say 'a basic register', what is it you need. I will see if I have a template for that. Again excel based.

@user-bt1vl3mo9m 5 месяцев назад

First of all, thank you so much for creating such an informative video and supplying such a nice Journal template. I am wondering if you have a template for accounts payable, accounts receivable and payroll? I thought of trying to create my own, but I examine your formulas and became lost. I'm afraid my knowledge only extends to only the most basic math and algebraic functions.

@TheBookkeepingChannel 5 месяцев назад

What exactly are you looking for? I plan on creating more templates so let me know what you need. Feel free to get my email address from my YT channel.

@stevepaglia4805 5 месяцев назад

Thank you! - I've been looking for a straightforward template like this! - I switched to "Use 1904 Date", since most other spreadsheets in USA are set there. Only ISSUE: I noticed if I add a Category Name, then the drop boxes fail. What is the simple fix? Thank you!

@stevepaglia4805 5 месяцев назад

Also, I am using Excel 2010, if that matters...

@stevepaglia4805 5 месяцев назад

I' been trying to fix it - but the drop box in Transactions just shows a list of 30 of this: #NAME?

@naemagraham649 4 месяца назад

Can this just take stock of the items? With photo of the items

@user-pe6vz1rz7i 6 месяцев назад

hey i filled out everything for me but on transactions my lines are grey

@halleluyastudio Месяц назад

why is the profit/loss always positive?

@steveparry4455 3 месяца назад

Hello and thankyou so much for this free template it is perfect for my small business. Is there anyway of increasing the transactions past 1000? i sell on ebay and my transactions will go past the 1000 limit

@RamazanGurpnar-rt1bt Месяц назад

is that usa or uk

@dikshitdas3348 6 месяцев назад

how do i add more catagory type and name

@mkammkam477 8 месяцев назад

Hi! Can’t find the spreadsheet… 😟

@nowshinahmed8851 9 месяцев назад

Hi ! do you have the google sheet on Canadian date format? or can you tell me how to do that?

@TheBookkeepingChannel 9 месяцев назад

There's US and International formats available to download. Are either of those ok for you?

@nowshinahmed8851 9 месяцев назад

well i have managed to change the format in transactions but not in the report. @@TheBookkeepingChannel 🙂

@biblosetuna3333 4 месяца назад

how can i add monthly report?

@leahgwenromo2975 Месяц назад

Hi, can I have a copy of Microsoft excel template

@bradheck9630 3 месяца назад

I like the spreadsheet but need a couple more income lines or at least the refund to customer to show a positive, as we do not refund payments. We are a small business that has sales and service. We do not refund product or service. I am in to process of setting up the spreadsheet and think it will be fine for awhile. Do you have any other products for when we need a bigger accounting package?

@samuela775 6 месяцев назад

can you use this for more than a month- eg from august 2022 to November 2023?

@TheBookkeepingChannel 5 месяцев назад

Yes you can

@markyem6116 3 месяца назад

I am not able to see the link to down load the template. Please could you help me out. Thank you@@TheBookkeepingChannel

@TheBookkeepingChannel 3 месяца назад

@@markyem6116 Links are in the description

@user-le8yx3bh2z 5 месяцев назад

seems brilliant but all of a sudden my grey blocks on the transaction tab are staying grey and not going green

@TheBookkeepingChannel 5 месяцев назад

Which version?

@bs9855 3 месяца назад

@@TheBookkeepingChannel I am also having this problem on the international dates google sheets version. error boxes seemed to have stopped working but the figures are still updated in reports. is there a way to fix this? thanks ]

@dennyg1651 5 месяцев назад

I downloaded the template and am using it to keep the books for a private club. However, I have found a problem. The second income space is recording as a debit on the report sheet. How can I correct this?

@TheBookkeepingChannel 5 месяцев назад

I'll numbers must be entered as positives. Income should be correct if entered as a positive.

@szweifel1 3 месяца назад

@@TheBookkeepingChannel I have also had this problem. Everything I enter as a positive number in the second income space comes into the report as a negative.

@ExcelTemplatesSolutions 2 месяца назад

Found the solution?

@JoseSanchez-nl2xm 3 месяца назад

I downloaded and when I got to cell 105 the green and red boxes stopped appearing. Could you let me know why that happened and how to fix it? Thank you on the google sheets version.

@TheBookkeepingChannel 3 месяца назад

Can you download again and retry? I've made some changes. Thanks.

@JoseSanchez-nl2xm 3 месяца назад

@@TheBookkeepingChannel I will try it tomorrow or this weekend. Thank you

@JoseSanchez-nl2xm 3 месяца назад

@@TheBookkeepingChannel It worked Thank you for the update!

@bryanbendelow9733 5 месяцев назад

I am trying to use the Excel US Dates but when I try to change or add my own items in category name it makes the drop down list on the transactions page go to #NAME? how can I fix or get this to work???

@TheBookkeepingChannel 5 месяцев назад

Hi there. I've uploaded a new version that should have fixed that issue. Can you download a new copy and try again? Let me know if it's ok. Thanks.

@samuelagina1 3 месяца назад

Please If you can just share how to add more columns to a category, I will really appreciate it.

@johnvanek1 4 месяца назад

You have REFUND to customer as Income which creates a negative value (Excel, USA model). Can you please explain how to fi this?

@TheBookkeepingChannel 4 месяца назад

If you enter the transaction as a postive number it comes through as a negative number on the Income Statement and gets subtracted from Sales Revenue.

@johnvanek1 4 месяца назад

But I don't want it to subtract. I want the Refund line to be a positive income catagorie @@TheBookkeepingChannel

@akashhalder2871 9 месяцев назад

The date colour column become blank (no color) after putting correct date in date range

@TheBookkeepingChannel 9 месяцев назад

On which version?

@bradheck9630 3 месяца назад

Does Bullseyemoney read the comments? I would be nice to be able to communicate with someone connected to Bullseyemoney. I would really like to use a spread sheet like this one but I need just a few more lines in a couple categories. thanks for your help. Brad

@TheBookkeepingChannel 3 месяца назад

Hi Brad. Please email me at bullseyemoney@outlook.com and let me know which version you're using and what you need. Thanks.

@bradheck9630 3 месяца назад

Thank you so much for the quick reply and help. very appreciated.

@BeaWinterfeld 9 месяцев назад

When I make a change to a category name in Settings, the drop-down box inTransactions goes to" #Name?".How do I fix this?

@TheBookkeepingChannel 9 месяцев назад

Which spreadsheet in particular?

@BeaWinterfeld 9 месяцев назад

I am using Excel and the US time @@TheBookkeepingChannel

@daneweatherby3173 7 месяцев назад

Try to change catagory name list to my own list, and the drop down in transactions goes to #NAMES.

@daneweatherby3173 7 месяцев назад

US DATE

@TheBookkeepingChannel 7 месяцев назад

Which version are you using?

@nzer57 5 месяцев назад

Doesn't include GST calcs.

@YellowPineappleHoyas 6 месяцев назад

It doesn’t work. I enter a category and nothing changes.

@TheBookkeepingChannel 6 месяцев назад

Which version?

@himelhasan9888 5 месяцев назад

link doesn't work

@TheBookkeepingChannel 5 месяцев назад

Which link?

@alexismesidor4995 4 месяца назад

call you mama

@Bewefau 2 месяца назад

What about home users for people who had a stroke ?

@YellowPineappleHoyas 6 месяцев назад

So lost. I find this incredibly confusing.

@brayan8346 5 месяцев назад

It's classic accounting. If you don't mind spending money, QuickBooks might be a better option.

@phoneblaster Месяц назад

...Hello pineapples, hope you doing good. Can I ask what is it you find confusing. I may have what you might be looking for? Again it is all excel based.