Table of Contents
Purpose
If you are using our Standard Aspire Accounting Solutions (SAAS) you will be managing your inventory in Aspire. You will also be reconciling the Inventory Holding Accounts on your balance sheet at the end of every month after entering the End of Month (EOM) Expense tab and Inventory tab journal entries.
It is best practice to enter a beginning inventory prior to using Aspire. You should also take an inventory count at the end of each month but no less than quarterly or annually.
Then, you can update the on-hand quantities in Aspire before closing the month.
Setting Up Inventory Items
Make sure that all inventory items have the box checked to make that item available for inventory.
Click on your Profile Icon in the blue side menu and select Administration.
Select the Estimating tab and then the Item Catalog tab.
Find the item that you will be using for Inventory or enter the item if it has not already been entered.
Make sure that the Inventory Item box is checked on the item.
Adding Existing Inventory into Aspire
You can now attach inventory items to purchase receipts!
Navigate to the Purchasing module.
Create a new purchase receipt using your company name as the vendor. If your company is not already set up as a vendor in your accounting system, please add it to your accounting system and allow the vendor to sync over to Aspire.
Enter the items to the purchase receipt that you want recorded into Aspires’ inventory. Enter the quantity and use the item cost from the item catalog in Aspire. The cost should automatically populate on the item line of the purchase receipt.
The received date should be the 1st day of your Go Live month in Aspire.
Once the purchase receipt is received and approved in Aspire, send it to your accounting system.
📑To learn more about Purchase Receipts for Inventory, please read this article.
Managing Initial Inventory in Your Accounting System
Once you approve the Purchase Receipt in Aspire, it will sync to your accounting system.
The automatic entry in your accounting system will be a debit to the appropriate Inventory Holding account and a credit to the Accounts Payable for the vendor.
You will want the vendor bill to remain in the Inventory Holding account, but you will want to clear the Accounts Payable balance for the vendor.
There are two ways that you can handle clearing the vendor bill from Accounts Payable. In either option, you will need to apply the vendor bill to the vendor credit:
Option 1
Create a Journal Entry if you show Inventory on the Balance Sheet. Create a journal entry debiting Accounts Payable with your company’s name in the Name portion of the journal entry. Credit the Balance Sheet Inventory Account.
If you do not show Inventory on the Balance Sheet, create a journal entry debiting accounts payable with your company’s name in the Name portion of the journal entry. Credit the appropriate COGS account for the materials.
The credit would be where the initial inventory purchase was coded or expensed.
Option 2
If you show Inventory on the Balance Sheet and If you are using QuickBooks, you can open the vendor bill in QuickBooks, create a copy, change the copy of the bill to a Credit and then delete the inventory holding accounts line from the credit and add the appropriate Inventory Balance Sheet Account.
If you do not show Inventory on the Balance Sheet and you use QuickBooks, you can open the vendor bill in QuickBooks, create a copy, change the copy of the bill to a Credit and then delete the inventory holding accounts line from the credit and add the appropriate COGS accounts.
The credit would be where the initial inventory was coded or expensed.