Differences

This shows you the differences between two versions of the page.

--- speedy:faq:how_to_complete_a_yearend [2010/05/04 08:56 (14 years ago)] – created mrobosa
+++ faq:how_to_complete_a_yearend [2021/03/12 14:46 (3 years ago)] (current) – tanya
@@ Line 1: / Line 1: @@
-==How to Complete a Year End==
+====== Year-End Procedure ======
+See [[https://support.windwardsoftware.com/a/solutions/articles/66000482026]]
-Contrary to popular belief, "year-ends" do not happen on the last day of your financial year. You must wait for bank statements and final supplier bills to arrive. Then, after posting all transactions that you are aware of, you send the information to your accountant and wait for the deprecation, tax planning and other adjusting entries to be returned to you. By the time you've completed your year-end, it could be months later.
+Contrary to popular belief, “year-ends” do not happen on the last day of your financial year. You must wait for bank statements and last supplier bills to arrive. Then, after posting all transactions you are aware of, you send the information to your accountant and wait for the deprecation, tax planning, and other adjusting entries to be returned to you. By the time you’ve completed your year-end, it could be months later.
+System Five allows you to post into the previous financial year and reprint all your accounting reports for a prior period. For example, on June 15 you can reprint the Balance Sheet, Income and Expense Statement, Aged A/R, and Aged A/P reports for December 31 of the previous year. Some other accounting systems allow you to reprint the Balance Sheet and Income and Expense Report, but very few allow you to reprint an Aged Accounts Payable report for a prior period in time. Even if the bills are now paid, System Five reports on the status of each customer and supplier for previous dates you will specify.
-SpeedyPOS allows you to post into the previous financial year and reprint all your accounting reports for a prior period at any time. For example, on June 15 you can reprint the Balance Sheet, Income and Expense Statement, Aged A/R and Aged A/P reports for December 31 of the previous year. Some other accounting systems allow you to reprint the Balance Sheet and Income and Expense Report, but very few allow you to reprint an Aged Accounts Payable report for a prior period in time. Even if the bills are now paid, SpeedyPOS reports on the status of each customer and supplier as of that previous date in time.
+Inventory, however, is more complicated. Print the Inventory Stock and Landed Report at the end of the last business day of your financial year after you have received all the stock and entered all the sales for the day. This is the most accurate report of the value of inventory on hand at the end of the year. Once you have printed the Inventory Stock and Landed Report, you can advance the financial year and continue selling at the point of sale.
-Inventory however, is more complicated. Print the Inventory Stock and Landed Report at the end of the last business day of your financial year after you have received all the stock and entered all the sales for the day. This is the most accurate report of the value of inventory on hand at the end of the year.  Once you have printed the Inventory Stock and Landed Report, you can advance the financial year and continue selling at the point of sale.
+===== Recommended Procedure to Complete Year-End =====
-Near the end of your financial year complete the following steps:
+**1. Count the Inventory** \\
+In the days and weeks before your year-end, count your inventory, and adjust the quantities. We recommend checking one sub-category per day to not create too much work on the last day of the year. If you are spot-checking your inventory regularly, adding the inventory as you receive it, and create all the invoices as you sell the goods, then you are running a perpetual inventory system. There is no reason to close your business for one or more days to count the inventory if you plan this correctly. On the last day of the year, all you need to do is print the report. \\
-.Count the Inventory
+**2. Add/receive the new stock that has arrived** \\
-In the days and weeks before your year-end, count your inventory and adjust the quantities. We recommend checking one sub category per day so as to not create too much work on the last day of the year. If you are spot-checking your inventory on a regular basis, adding the inventory as you receive it and create all the invoices as you sell the goods, then you are running a perpetual inventory system. There is no reason to close your business for one or more days to count the inventory if you plan this correctly. On the last day of the year, all you need to do is print the report.
+Ensure that all the inventory that arrived are entered/received into stock. \\
-.Add/receive the new stock that has arrived
+**3. Close all the Sales** \\
-Ensure that all the inventory that has arrived is entered/received into stock.
+This is to ensure that the sold inventory is removed from stock before the inventory report is printed. \\
-.Close all the Sales
+**4. Print the Inventory Valuation Reports** \\
-This ensures that sold inventory is removed from stock before the inventory report is printed.
+Print the reports that tell you how much inventory you have on hand. You can print a detailed inventory list (Stock and Landed Report) that has lists of all inventory items or just a summary by sub-category. Do not forget to print the Open Workorders/Layaways as they contain inventory that has been reserved for customers but not yet delivered to the customer. \\
-.Print the Inventory Valuation Reports
+**5. Backup the Data** \\
-Print the reports that tell you how much inventory you have on hand. You can print a detailed inventory list (Stock and Landed Report) the has each inventory item or just a summary by sub category. Do not forget to also print the Open Layaways /Laybys  as they contain inventory that has been reserved for customers but not yet delivered to the customer.
+This is one of the most important steps. Create a backup of your data that can be restored if you have forgotten anything. If the inventory reports later look incorrect, you’ll be able to check the detail if required. Keep this backup secure. \\
-.Backup the Data!!
+**6. Advance the Financial Year** \\
-This is one of the most important steps. Create a backup that can be restored if you have forgotten anything. If the inventory reports later look incorrect, you'll be able to check the detail if required. Keep this backup safe and secure.
+This step sets up the next year so you can continue selling and doing business. Go to [[https://selfhelp.windwardoncloud.com/System5Closing_Routines_command.htm|Closing Routines]] and advance the financial year. \\
-.Advance the Financial Year
+**7. Keep working and do not get behind** \\
-This step sets up the next year so that you can continue selling and doing business.  Go to Closing Routines and advance the financial year
+Now that you are in a new financial year, it is most important to keep up-to-date on all your daily work such as creating new invoices and bills. Bills that are for inventory received in the previous year should be posted back into that previous year. Bills that are for inventory received in the new financial year should be posted into the new year. At the same time, you can write off bad debts, reconcile your bank, and do all the other things you need to for the end of the previous year. \\
-.Keep working and do not get behind
+**8. Check the Inventory Value** \\
-Now that you are in a new financial year, it is most important to keep up-to-date on all your daily work such as creating new invoices and bills. Bills that are for inventory received in the previous year should be posted back into that previous year. Bills that are for inventory received in the new financial year should be posted into the new year. At the same time you can write off bad debts, reconcile your bank and do all the other things you need to for the end of the previous year.
+Once you have received all the bills for inventory received in the previous year, print a Balance Sheet and compare the value of inventory on hand at the end of the previous year to the inventory valuation report you printed. These numbers should be the same, but in reality, they never are. Create an adjusting journal entry to change the value in the ledger, to agree with the inventory report, and post the difference to the cost of sales. If the difference in value large, you’ll need to find out why and correct the error. Technical Support may help you track down some causes. \\
-.Check the Inventory Value
+**9. Print and Check the Balance Sheet** \\
-Once you have received all the bills for inventory received in the previous year, print a Balance Sheet and compare the value of inventory on hand at the end of the previous year to the inventory valuation report you printed. These numbers should be the same, but in reality they never are. Create an adjusting journal entry to change the value in the ledger to agree with the inventory report and post the difference to cost of sales. If the difference in value large, you'll need to find out why and correct the error. Technical Support may be able to help you track down some of the causes.
+Check is the Proof at the bottom of this report. It should be zero. Common accounting principles dictate that the Assets should equal the Liabilities plus Owner Equity. The Proof is the difference between the two; therefore, if they are equal, the Proof should be zero. \\
-.Print and Check the Balance Sheet
+**10. Print and check the Income and Expense Report** \\
-Check is the Proof at the bottom of this report. It should be zero. Common accounting principles dictate that the Assets should equal the Liabilities plus Owner Equity. The Proof is the difference between the two; therefore if they are equal, the Proof should be zero.
+The total net profit in the year-to-date column should equal the Current Earnings on the Balance Sheet. If they are not equal, you may have added some ledger numbers since the last time you created the report. Run the report again and review it. When those two numbers agree, you can be reasonably certain the report is OK. \\
-.Print and check the Income and Expense Report
+**11. Print and Check the Aged A/R Report** \\
-The total net profit in the year-to-date column should equal the Current Earnings on the Balance Sheet. If they are not equal, you may have added some ledger numbers since the last time you created the report. Run the report again and review it. When those two numbers agree, you can be reasonably certain the report is OK.
+The Aged A/R report shows the total amounts owed to you by each client at the end of the year. The total amount owing at the bottom should equal the value of Accounts Receivable on the Balance Sheet. If not, you’ll need to find out why and fix it. It could be the options you selected when printing the report. \\
-.Print and Check the Aged A/R Report
+**12. Print and Check the Aged A/P Report** \\
-The Aged A/R report shows the total amounts owed to you by each client at the end of the year. The total amount owing at the bottom should equal the value of Accounts Receivable on the Balance Sheet. If not, you'll need to find out why and fix it. It could be the options you selected when printing the report.
+The Aged A/P report shows you the total amounts owed to each supplier and should agree with the value of Accounts Payable on the Balance Sheet. \\
-.Print and Check the Aged A/P Report
+**13. Send reports to your Accountant** \\
-The Aged A/P report show you the total amounts owed to each supplier and should agree with the value of Accounts Payable on the Balance Sheet.
+Send copies of the Balance Sheet, Income and Expense Report, Aged A/R and Aged A/P reports to your accountant. They may also request a copy of your inventory report, but normally they just require the total inventory value. They may also request details from some accounts, such as advertising expenses. You can print a transaction report for the accounts requested, but don’t print the list for all accounts as it is very lengthy. If the accountant wants a list of all transactions for all account numbers, you can print the report or export the report to Excel spreadsheet and save it in your local drive or save it elsewhere (external drive). \\
-.Send reports to your Accountant
+**14. Final Adjustments** \\
-Send copies of the Balance Sheet, Income and Expense Report, Aged A/R and Aged A/P reports to your accountant. They may also request a copy of your inventory report, but normally they just require the total inventory value. They may also request details from some accounts, such as advertising expenses. You can print a transaction report for the accounts requested, but don't print the list for all accounts as it is very lengthy. If the accountant does want a list of all transactions for all account numbers, you can print that report to a disk file and copy it to a CD or Zip disk.
+When your accountant is done, you will get a list of adjusting entries for depreciating some of your assets and other calculations that are important. Create a journal entry for each of these and post them to the last day of the previous financial year.
-.Final Adjustments
-When your accountant is done, you will get a list of adjusting entries for depreciating some of your assets and other calculations that are important. Create a journal entry for each of these and post them to the last day of the previous financial year. That's it, you're finished.
- Technical Support is always available should you have questions.
+===== Closing of Minimum Book Month =====
+**[[https://academy.windwardoncloud.com/#/assetviewer?id=30013806-de7a-413c-4571-ed4b07da570d|Book Month]]** is Windward term that describes the accounting period to which the system posts transactions. Windward System Five has separate Book Months: sales (A/R Book Month), accounts payable (A/P Book Month), and General Ledger (Ledger Book Month). The Book Months advance automatically.
+The Minimum Book Month prevents users from editing posted entries (Invoices, Journal Entries, etc.) that have occurred before the minimum book month. Also, it will change the "Unposted Book Month" on all Estimates, Work Orders and Layaways so that they can be edited even if they were created before the current minimum book month.
+To advance the Ledger Book Month select the following menu path: General Ledger > [[https://selfhelp.windwardoncloud.com/System5Closing_Routines_command.htm|Closing Routines]].