00:00Hi there! Today I'll show you how to use the Easy Bookkeeping Template, which is available for
00:06purchase on our website SpreadsheetsHub.com. This template helps you easily track income and
00:12expenses, keep your finances organized throughout the year, and stay on top of your bookkeeping with
00:18clarity and confidence. Before you begin, take a moment to review the instructions on the first
00:24page. They explain how to use the template step by step. Steps 1 and 2 show you how to specify
00:32the
00:32main categories of income and expenses and enter your monthly budgets. The following steps explain
00:40how to specify accounts and analyze their balances. The next step shows how to enter your current income
00:47and expenses. The next section explains how to analyze a monthly budget, helping you clearly
00:54understand where your money goes, identify spending patterns, and make better financial decisions.
00:59The annual overview sheet summarizes your financial activity for the year, allowing you to track total
01:06income, expenses, and savings in one place, and easily see your overall financial picture. The
01:13following section explains how to analyze data for a randomly selected period, helping you review specific
01:19time frames, identify financial patterns, and better understand your income and expenses. This step shows
01:27how to analyze data from the past five years, helping you identify long-term financial trends, track changes
01:33in income and expenses, and better understand your financial progress over time. The final step shows how to
01:41analyze annual tax data. Go to the settings sheet. Before entering information, select the year and base currency.
01:50In the revenue table, specify a list of revenue sources such as Etsy, Shopify, Amazon, affiliate programs,
01:58freelance work, consulting, or other business activities.
02:10You can list up to 50 sources of revenue. Enter the planned revenue data into the table below.
02:17The years in this table are updated automatically based on the year selected above.
02:25In the costs table, specify a list of expense categories such as material, packaging, labor,
02:31postage, and delivery, marketing, subscriptions, or other business-related costs.
02:44In the table below, specify monthly cost budgets.
02:54In the table below, specify monthly cost budgets.
03:01Go to the accounts sheet. Go to the accounts sheet. On this sheet, in the table below, please list the
03:06accounts and their current balance.
03:09A drop-down list for the operations tracker sheet will be generated based on this account list.
03:18The account data on this sheet is updated automatically based on the amounts entered in the operations tracker sheet.
03:25Let's enter the transaction data and then return to the account analysis sheet.
03:32In this table, you need to list your current income and expenses.
03:37Enter the date.
03:40Select revenues or cost.
03:42Select the category.
03:44The drop-down list is generated based on the data specified on the settings sheet.
03:50Select the currency.
03:53Enter the amount.
03:55The data in these columns is updated automatically.
03:58Enter the data in the tax, shipping, and fees columns.
04:03The amount in the column is calculated automatically.
04:07Select the account.
04:08The list of accounts is generated based on the data specified on the accounts sheet.
04:14Let's enter some more data.
04:31You can also specify transactions in any currency.
04:35And the amounts will be automatically converted to the base currency at the current exchange rate.
04:41To make things easier for you, the input cells are highlighted in light blue,
04:46and the formula cells that update automatically are marked in light pink.
04:51It's best not to change the formula cells, as this could disrupt the calculations.
04:55These cells are also locked for protection.
04:58If you still decide to modify a formula, just enter your data and click OK when prompted.
05:04The formula will be updated.
05:07In the Excel version, you can unlock the sheet without a password if needed,
05:11but we recommend leaving the formulas untouched to ensure everything functions correctly.
05:16Go back to the accounts tab.
05:18You can see that data has appeared in these columns.
05:21The money in column shows the amounts of income received.
05:25The money out column shows the amounts of expenses.
05:29This chart allows you to analyze the breakdown of the actual account balances.
05:34This chart displays the balances for each account, helping you quickly see which accounts hold the
05:40most funds, monitor changes over time, and make informed financial decisions.
05:45Go to the monthly overview sheet.
05:49The data on this sheet is updated automatically.
05:52You just need to select the year and month.
05:56The model is in English by default, but if you want to translate the tables into another language,
06:02you can use our Translate Hub tool.
06:04It's quick, accurate, and super easy to use.
06:07You'll find the link in the description below.
06:09Let's return to the model.
06:12This section shows the summary data on revenue, expenses, and profit.
06:17The monthly profit target chart shows the percentage of your profit goal achieved.
06:22This chart helps you quickly see whether you are on track to meet your monthly targets
06:26and make adjustments to improve your financial performance.
06:30In these sections, you can analyze how your current income and expenses align with your established plan and budget.
06:39The sales distribution chart shows the revenue breakdown.
06:43Using the chart below, you can analyze revenue amounts by category.
06:48The expense distribution chart shows the breakdown of expenses.
06:52You can use the chart to analyze the amounts by expense category.
06:56More detailed information on income and expenses can be found in the tables below.
07:01The sales chart allows you to analyze revenue trends by day,
07:06helping you quickly identify peak sales periods, track performance over time,
07:11and make informed decisions to increase revenue.
07:14The expense chart shows the trend in expenses by day, allowing you to spot high cost days,
07:20monitor spending patterns, and manage your budget more effectively.
07:24Go to the annual overview sheet.
07:27On this sheet, select the year and all the data will update automatically.
07:32This section shows the summary data on revenue, expenses, and profit.
07:37The yearly profit target chart shows the percentage of your annual profit goal achieved throughout the year.
07:43In these sections, you can review how your actual income and expenses compare to your planned budget.
07:51The sales distribution charts display how revenue is divided across different categories,
07:57allowing you to analyze the amounts for each one.
08:00The expense distribution charts show how expenses are allocated by category,
08:05helping you see how much is spent in each area.
08:08For more detailed information, refer to the tables below.
08:13The sales overview chart highlights monthly revenue trends,
08:17helping you identify peak periods and track performance.
08:21The expense overview chart shows monthly expense trends,
08:25helping you spot high cost periods and manage your budget effectively.
08:29Go to the financial year sheet.
08:31On this sheet, select the analysis period and the data will update automatically.
08:38This section provides a summary of revenue, expenses, profit, and profit margin,
08:43giving you a clear view of your overall financial performance.
08:47The sales chart shows the revenue breakdown.
08:51Using the chart below, you can analyze revenue amounts by category.
08:55The expense chart shows the breakdown of expenses.
08:59You can use the chart to analyze the amounts by expense category.
09:03More detailed information on income and expenses can be found in the tables below.
09:08The chart tracks daily revenue trends, helping you identify peak sales days,
09:14monitor performance over time, and make smarter decisions to increase income.
09:18The chart shows daily expense trends, allowing you to spot high spending days,
09:24track spending patterns, and manage your budget more efficiently.
09:27Go to the five-year sheet.
09:29On this sheet, you need to enter the years and the data will update automatically.
09:36This section summarizes your revenue, expenses, profit, and profit margin,
09:42giving you a clear overview of your financial performance.
09:45In this section, you can analyze your income, expenses, and profit for each year in more detail.
09:52The chart shows the breakdown of revenue sources by year,
09:56helping you quickly see which sources contribute most to your income,
10:00track trends over time, and make informed decisions to optimize your revenue streams.
10:05The financial summary chart shows revenue, expenses, and profit by year.
10:11The chart shows the breakdown of expenses by year, helping you identify major cost areas,
10:17monitor spending patterns over time, and make informed decisions to better manage your budget.
10:22The chart highlights the breakdown of revenue across categories, allowing for quick comparison of income streams.
10:29Using the chart below, you can analyze revenue amounts by category.
10:34The chart breaks down expenses by category, helping you evaluate spending patterns effectively.
10:40This chart helps you examine how much is spent in each expense category.
10:44More detailed information on income and expenses can be found in the tables below.
10:49The sales overview chart shows actual and planned revenues by year, helping you compare performance against targets,
10:57identify trends over time, and make informed decisions to improve sales.
11:02The expense chart shows actual and budgeted amounts by expense category, allowing you to monitor spending,
11:09spot variances, and better manage your budget.
11:12Go to the annual reporting sheet.
11:17The data on this sheet updates automatically, allowing you to analyze taxes by month and year.
11:23Years are based on the data from the settings sheet, and tax information comes from the operations tracker sheet.
11:30One technical point, if you're using the Excel version of this report,
11:34we recommend using Excel 2021 or later to ensure all formulas work correctly.
11:40Also, please avoid opening the Excel file in Google Sheets.
11:43If you prefer working in Google Sheets, we suggest using the dedicated Google Sheets version of the report instead.
11:51Enter your own data to easily track income, expenses, and overall business performance.
11:57The template is available for download via the link in the description.
12:02For more personalized solutions, our team can build custom tables tailored to any level of complexity.
12:08We also offer templates with resale rights, along with an open affiliate program for those interested.
12:15Thanks for watching, and have a productive day.
12:38Visit our website to ensure you know how to watch the notification announcement of your Apple channel.
12:38I can click on the link, and see if you click on the link.
Comments