End of Year Accounting Cheat Sheet

Ending the Fiscal Year of a business is an important step. Several data files are archived, purged, and/or reset for the new year. The dataset that held the closing year's data is archived and a new year's dataset is created. The starting balances in the new year's dataset are set.  As such, after the Year End Process has been completed, great care should be taken in the event that adjusting entries or corrections may need to be made.

As a general rule, transactions should not be entered in the prior year, only adjusting Journal Entries. If entering an adjusting entry is not applicable, contact SSI Support.

Customers

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
Adjustment to Previous Year's InvoicesCreditCustomer Invoices should not be changed in the prior year's dataset as the changes will not flow into the current year.
Reverse
Void
Adjustment to Previous Year's PaymentsReverseCustomer Payments should not be changed in the prior year's dataset as the changes will not flow into the current year.
Void
Missed Entering a Payment/Invoice before End of Year
Customer transactions entered in a previous dataset, after the year has been closed, will not carry forward. Best practice is to enter the missed Invoice or Payment in the current year's dataset. 
Transfer to Field History
If Transfer to Field History was not posted during the end of year process, the transactions can be manually added to both the current and previous years' datasets. For more information, please refer to the Transfer to Field History article, found here.
Quotes
Provided the Quotes have not expired, they will carry forward to the new year and can be accessed from the new dataset.
Bookings
Paid and unpaid Bookings carry forward to the new year and remain available for use, so long as they have not been fully invoiced. Changes to current Bookings should be made in the current dataset.
Unprocessed Delivery Tickets
Best practice is to process all Delivery Tickets prior to the close of year. Any remaining unprocessed Delivery Tickets will carry forward to the new year and remain available to be processed.

 

G/L

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
Bank Deposit Entries
Prior to End of Year, best practice is to deposit as many outstanding entries as possible. Any undeposited entries, will carry forward into the new year. When ready to deposit those entries, do so in the current year. For more information, please refer to the Bank Deposit at End of Fiscal Year article, found here.
G/L Budget G/L Budget Numbers did not come in as expected during EOY process

!

If the options for Clear G/L Budgets, Move Next Year's Budget Numbers to Current, or Move Only Non-Zero Budget Numbers were not correctly selected during the EOY process, adjustments can be made using the G/L Budget Utility. Information about the EOY G/L Budget Options can be found here. For assistance with the G/L Budget Utility, please contact Support.
Year-End Adjustments
Depending on the type of adjustment, Year-End Adjustments may need to be entered in the previous, current, or both datasets. For more information, about adjustments, please refer to the Year-End Adjustments article, found here.

 

Inventory

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
Purchase InvoicesEditPurchase Invoices do not carry forward to the new year. 
VoidTransactions should not be entered in a previous year's dataset. An accrual entry for the correction could be made in the prior year if needed. 
Purchase Orders
Changes to an open PO should be made in the current dataset.
Purchase Receipts
If there is inventory remaining on a Purchase Receipt, the PR will carry forward into the new year and remain available for use. 
Zero-out Lots
If the Delete Lot Data option was not selected at the close of the year, Lots can be removed in the current dataset via the Purge Zero Balance Lot Numbers utility. For more information, please refer to the Delete Lot Numbers article, found here.

 

Payroll

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
W2sAttendance TotalsAfter ending the Payroll Year, reset balances at Accounting / Payroll / Attendance before entering new attendance and payroll information.  For more information please refer to the Payroll End of Year Information article, found here.
Employee Totals Report: Period to Date and YTD totals do not match

!


Please contact SSI Support for assistance.
Print
If W-2s were not printed prior to ending the year they can be printed from the previous dataset. For more information please refer to the Payroll End of Year Information article, found here.

Products

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
Non-Inventory ItemsIncorrect On-hand QuantityOn-hand quantities on non-inventoried items do not impact financial statements. As such adjustments can be made in either data-set. 
Note: Adjustments made in a previous dataset will not carry forward and a matching entry must also be made in the current dataset.
Inventory ItemsIncorrect On-hand Quantity

!

Entries will most likely need to be made in both datasets. Due to the potential impacts on costs and financial statements, a company's accountant may want to be involved in any potential correcting entries. For more information, please refer to the Fiscal Year End with Incorrect Amount On-hand article, found here or reach out to Support.

 

Vendors

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
1099sFY not December 31

!


Please refer to the Archiving Vendor 1099s When Fiscal Year does not Equal December 31 article, found here.
PATR Box 3Please refer to the End of Year 1099-PATR Box 3 Considerations article, found here.
PATR Box6
Please refer to the 1099-PATR Box 6 Considerations article, found here.
Vendor 1099 Summary Report incorrect

The 1099 paid amount can be changed by going to Hub / Utilities / Admin Utilities / Accounting / Edit Vendor Balances.
Add an A/P BillPost to Prior Month

!


If the current month is fiscal month 1 and the prior month is archived into a prior year dataset, the option to post to the prior year's dataset is available. For more information, please refer to the Add a A/P Bill article, found here.
Correct Vendor Prepay Balance

!


Certain conditions apply. For more information, please refer to the Correct Vendor Prepay Balance Across Fiscal Year End article, found here.
Vendor DisbursementVoid/ReverseCertain conditions apply. For more information, please refer to the Voiding / Reversing Vendor Disbursements article, found here.

 

General Information

Please contact the SSI Support team with any questions regarding the processes referenced below.

Change or AdjustmentPrevious DatasetCurrent DatasetNotes
Confirm End of Year Happened
Check the Fiscal Month on the status bar or check Journal Entries. Only Future Journal Entries should display in the list box. If Future Journal Entries or Post Transactions to Future Month is not used, no journal entries will display in the list box.
Delete Customers or Products
Provided the Customer or Product has no activity in the past, and if Patronage is not being paid, they may be deleted after ending the year. However, if the Customers or Products had Invoices or Delivery Tickets in the past, they can be flagged as Inactive but not Deleted.

 

Reminders & FAQs

TopicNotes
Archived DatabasePrior Year Databases are archived as 'FY', followed by the 1st two letters of the current dataset folder, plus the Year selected in the Archive Database Name.
Example:
Data folder = Avdata
Archive Year = 2023
Prior Year folder name = FYAv2023
AR Invoices & Delivery Tickets AR Invoices & Delivery tickets are not deleted during the End of Year process. If an Invoice is Reversed, the Delivery Ticket will reopen. 
End Payroll or Fiscal Year First?It does not matter if the FY or Payroll Year is ended first. It is important to make sure all payroll checks for the current year are posted before ending the payroll year. 
The expense for the payroll checks posted after running EOY will post into Fiscal Month 1 of the next year.