Below is some important information about where to find important numbers for year end within SimpleConsign. These numbers are best obtained on the last business day of the year or the first of the new year, others you will have to run a date range - your accountant should tell you what you need.
Gross Sales: Gross sales is found on the Sales Report (Reports Tab> Sales Report), run the report for the entire year. Sales Total is found at the bottom of the top box.
Sales Tax: Sales tax is found on the Sales Report (Reports Tab> Sales Report), run the report for the entire year. Sales Tax is the second number from the bottom of the top box. This is a combined total of the taxes listed in the Back Office (Settings> Taxes). For most stores you will probably have just one tax listed. Your accountant will be able to divide up city, state, and federal.
Money Paid to Consignors: Payout amount is found on the Payout Activity Report (Reports Tab> Payout Activity), run the report for the entire year. At the top you will see total payouts, totals of each payout type (cash, check, ACH).
Money Owed to Consignors: Run the Outstanding Balances by Date Report (Reports Tab> Outstanding Balances by Date), there are two numbers on this report. The Consignor Payout Balance is the total amount of money that can be paid out. The Consignor Total Balance is the same but it includes negative consignor balances. Store credit is also included on this report.
Cost of Goods for Store Owned Inventory: Cost of Goods is found on the End of Day Report (Reports Tab> End of Day), run the report for the first day of the year or last day of the year. On the bottom right, in the Inventory Summary box you will see the starting inventory cost and ending inventory cost for the time period on the top of the report.
Inventory Value: Current Inventory Retail and Current Consignment Inventory Retail is found on the End of Day Report (Reports Tab> End of Day), run the report for the first day of the year or last day of the year. On the bottom right, in the Inventory Summary box you will see Current Inv Retail and Current Consign Inv Retail.
Buy Count: If your store does buy out right from customers this custom report will give you the total buys for the year. Go to the Reports Tab> Custom Reports> Inventory, pull these fields in to view and add buy date twice as a filter-
Cash Ins and Outs: If you need a report of all of the cash ins and outs made by cashiers on terminals run the Cash Ins and Out Report (Reports Tab> Cash Ins and Outs), run the report for the entire year.
Notes on reducing inventory and donated items: If you have an item with a quantity of 6 for example and you wanted to donate 3 of them. This is how we would recommend you do that.
-Create a category called Donated.
-Manually reduce the quantity from 6 to 3 on the item.
-Create another item with a quantity of 3.
-Edit the item that you created (that has the quantity of 3) to be in the Donated category.
The reason you would take this approach is you want to track the total quantity donated. If you just mark something as donated status the software zeros the quantity and you no longer know how many you donated.
If you have an item that you are donating all of the quantity of you can just edit the item's category to be Donated.
A custom report of items in the category can be built to give you the list of all items, you can print that and then change the status of that inventory to donated status. Once you change to donated status the item's quantity will be zeroed out.
Below is an example of a custom report to show what was donated. Note that you want to filter by Last Modified because typically the last time you modify an item it's to donate it.
If you are not concerned with tracking the quantity of what was donated you can just mark items with donated status. Example of an inventory report that shows what is in donated status.