hi I'm Aimee from Razor Accounting if you're enjoying the content on this
channel please hit that subscribe button below and also hit that little bell next
to subscribe that's going to give you a notification when I post a new video to
this channel if you're liking my videos please hit that like button and also
leave a comment if you have a question or if you have an opinion that you want
to share this is an Excel tutorial on how to build a simple revenue
spreadsheet to add up your revenues from your business for a specified period
this is part of an Excel series called Excel for small businesses this series
is focused on businesses that are not large enough at this time to have a need
for a bookkeeping software but do you have the need to stay financially
organized for record-keeping and tax purposes when you're building your Excel
spreadsheets in this series please be mindful of your tax reporting periods
you should be separating your revenues and expenses into the correct periods
and therefore you should be creating new Excel workbooks for each reporting
period
when building your revenue spreadsheet there are three things that are very
important one the date of the revenue was earned two the amount of revenue
that was earned and the applicable sales tax and three the type of revenue that
was earned I'm going to start building my revenue spreadsheet in the top left
corner in column a row one so I'm going to put date in the first cell and then
Excel I'm going to put an abbreviation for invoice as inv and the number sign
so this will be where I put the invoice numbers tapping over to the next column
I'm going to put in customer
tabbing over to the next column I'm going to put total this will be the
total amount that the customer paid and tabbing over to the next column I'm
going to put tax so this would be the sales tax that's collected on the
invoice the next columns are going to be used for different types of revenue and
this is where you are going to personalize this spreadsheet for your
business I've added some common revenue categories to my spreadsheet but if you
only have one type of revenue in your business you only need one revenue
column the last column should be a check so put check in the last cell of your
table and the final step is to lock the top row so select the top row by going
over to the left side and highlighting the whole row go up to the top menu
under the tab that says view select freeze panels and then go down to where
it says freeze top row
this will allow you to add lots of data on your spreadsheet and move down the
page and never lose the words in your top row now you can go ahead and start
adding all of your revenues to your spreadsheet now that I have all the data
filled in in my revenue spreadsheet I'm going to use the check column over here
to make sure that I don't have any data entry errors and to do this I need to
use a formula so I'm going to click in the cell here put an equal sign in the
cell then go over to the total column and click in the first cell that has
data in it then put in the minus sign then put an SUM for sum and a bracket
they're going to highlight from the tax column all the way to the end of your
revenues then you're going to close with another bracket and then select enter
then click in the cell and drag down to fill in the formulas for all of the rows
you'll see that a number came up in the tech column here that means that I have
an error in my table so correcting the errors that you may have in your table
and once everything is correct you should have all zeros in your tech
column the last thing you have to do when you're finished with putting into
all your revenues onto your revenues table is to add them all up the easiest
way to add up all of your revenues is to use this thumbing feature so go over to
your total column and highlight all the data in that column then in your top
menu go to the Home tab and then go all the way over to the
right side and select autosum
now you'll see that the total column has been summed up in this bottom cell now
you don't have to do that for every single column instead you can select the
cell and click in the corner and drag all the way to the right and all of your
formulas will be filled in once I have all my sums at the bottom I
like to highlight all of the summed amount and then I like to go up to the
top menu again under the Home tab and in here select the top and double
bottom border this way I know that all of these bottom numbers have been summed
up if you would like to make your revenue spreadsheet look a little bit
more interesting you can always add some color all you need to do is highlight
the cells go up to your top menu under the Home tab and select whatever color
you'd like so now that you've got all your revenues summed up for the period
it's time to start thinking about all the expenses for that period now you may
have noticed down at the bottom of my Excel workbook that I have another tab
here that's called expense spreadsheet that is the next excel tutorial in this
series I recommend that instead of creating a new workbook for your expense
spreadsheet but you do the same thing that I did you add another tab and
you're going to keep your revenues and your expenses or one period in the same
workbook to keep things organized and then for your next reporting period and
what I mean by that is like your next tax year you can make another excel
workbook for that year that's all for this excel tutorial on how to make a
simple revenue spreadsheet if you do have any questions about this please
leave a comment on this video and I'll be happy to answer your question as
quickly as I can and if you did like this video if you found it helpful
please leave it a like and don't forget to subscribe to the channel thank you
for watching