Purpose
In this article, we discuss options for you to build out a process for Bill Pay Systems. To allocate costs to a job or inventory, you would process a Purchase Receipt in Aspire.
Accounting for Purchase Receipts in Aspire
Transaction recorded in your accounting system
Debit — Inventory Holding Accounts
Credit — AP: Vendor you purchased from
EOM journal entry to record COGS or Expense
Debit — Cost of Goods Sold (COGS)/Expense by Division in Aspire (Class in QuickBooks)
Credit — Inventory Holding Accounts
- If you are Simplified SAS and are expensing items as they are purchased and are not managing Inventory on your Balance Sheet, the balance in the Inventory Holding Accounts at the end of the month will be zero after the Journal Entry.
- If you’re Standard SAAS and are expensing items as they are used on a job or adding to Inventory and manage Inventory on your Balance Sheet, the balance remaining in the Inventory Holding Accounts at the end of the month, after the Journal Entry, will be your Physical Inventory.
Note
These examples are only suggestions for GL account numbers. These suggestions only apply to direct expenses that run through Aspire for job costing. Continue your normal process for your Indirect Expenses.
There are 4 options to process a receipt.
- Using the invoice from your bill pay system and not from Aspire.
- Using the invoice from Aspire and not your bill pay system.
- Using the invoice from Aspire and deleting from your bill pay system.
- Using the invoice from your bill pay system and not from Aspire.
Option 1: Using the invoice from your Bill Pay system and not from Aspire
Aspire
- Inventory Holding – Aspire GL Accounts #1501 – 1504
- AP Account – Aspire GL Account #2000
Your Bill Pay system
- Inventory Holding – Bill Pay GL Accounts #1601 – 1604
- AP Account – Bill Pay GL Account #2010
For Aspire Purchase Receipts
- Credit Accounts Payable – Aspire – GL Acct #2000
- Debit Inventory Holding – Aspire GL Acct #1500
- Inventory Holding Material – GL Acct #1501
- Inventory Holding Equipment – GL Acct #1502
- Inventory Holding Sub – GL Acct #1503
- Inventory Holding Other – GL Acct #1504
- Reconcile Purchase Receipts Task #3 from EOM Checklist
From Bill Pay, code receipts to:
- Credit Accounts Payable – Bill Pay GL Acct #2010
- Debit Inventory Holding Accounts – Bill Pay GL Acct #1600
- Inventory Holding Material – GL Acct #1601
- Inventory Holding Material – GL Acct #1601
- Inventory Holding Equipment – GL Acct #1602
- Inventory Holding Sub – GL Acct #1603
- Inventory Holding Other – GL Acct #1604
- Task #3 – Review New Purchase Receipt List from EOM Checklist
For Aspire Purchase Receipts
After you reconcile Purchase Receipts in Aspire and your Bill Pay system:
- Delete activity in Accounts Payable – Aspire GL Acct #2000.
- The Aspire Inventory Holding – Aspire GL Acct #’s 1501 – 1504 and Accounts Payable Aspire – Aspire GL – Acct #2000 will be zero.
You can delete activity weekly.
EOM journal entry
This final EOM entry records the COGS and moves the inventory cost from the Bill Pay holding accounts to the COGS/Expense accounts:
- Debit – COGS Accounts by Division
- Credit – Inventory Holding – Bill Pay GL Acct #’s 1601 – 1604
Option 2: Using the invoice from Aspire and not your Bill Pay system
Create 2 sets of Inventory Holding Accounts and 2 sets of Accounts Payable Accounts.
Aspire
- Inventory holding –Aspire GL Accounts #1501 – 1504
AP Account – Aspire GL Account #2000
Bill Pay
- Inventory Holding – Bill Pay GL Accounts #1601 – 1604
- AP Account – Bill Pay GL Account #2010
For Aspire Purchase Receipts
Purchase Receipts are received and approved in Aspire. When they come into your accounting system they are recorded as:
- Credit Accounts Payable – Aspire – GL Acct #2000
- Debit Inventory Holding – Aspire GL Acct #1500
- Inventory Holding Material – GL Acct #1501
- Inventory Holding Equipment – GL Acct #1502
- Inventory Holding Sub – GL Acct #1503
- Inventory Holding Other – GL Acct #1504
- Reconcile Purchase Receipts Task #3 from EOM Checklist.
From Bill Pay, code receipts to:
- Debit Inventory Holding – Bill Pay GL Acct #1601 – 1604
Credit Accounts Payable – Aspire GL Acct #2010
Reconcile the transactions
- Reconcile the Accounting System/Bill Pay for the week/month with Aspire Purchase Receipt List #3 from the EOM Checklist.
- Delete transactions from Inventory Holding – Bill Pay GL Acct#1601 – 1604 as they show in Aspire.
- The Aspire Inventory Holding – Bill Pay GL Acct #1601 – 1604 and Accounts Payable – Bill Pay GL Acct #2010 will be zero.
EOM journal entry
This final EOM entry records the COGS and moves the inventory cost from the Bill Pay Aspire holding accounts to the COGS/Expense accounts.
- Debit COGS Accounts by Division
Credit Inventory Holding – AspireGL Accounts #1501 – 1504
Option 3: Using the invoice from Aspire and deleting from your Bill Pay system
With this option, you need to process invoices in Aspire and delete them from your Bill Pay system.
For Aspire Purchase Receipts
Purchase Receipts are received and approved in Aspire. When they come into your accounting system, they are recorded as:
- Credit Accounts Payable - Aspire – GL Acct #2000
- Debit Inventory Holding - Aspire – GL Acct #1500
- Inventory Holding Material – GL Acct #1501
- Inventory Holding Equipment – GL Acct #1502
- Inventory Holding Sub – GL Acct #1503
- Inventory Holding Other – GL Acct #1504
- Reconcile Purchase Receipts from Task #3 from EOM Checklist.
EOM journal entry
This final EOM entry records the COGS and moves the inventory cost from the Bill Pay Aspire holding accounts to the COGS/Expense accounts:
- Debit COGS Accounts by Division
- Credit Inventory Holding – Aspire GL Accounts #1501 – 1504
Option 4: Using the invoice from your Bill Pay system and not from Aspire
For Aspire Purchase Receipts
Create 2 sets of Inventory Holding Accounts and 2 Accounts Payable Accounts.
Aspire
Inventory Holding – Aspire GL Accounts #1501 – 1504
AP Account – Aspire GL Account #2000
- Inventory Holding - Bill Pay GL Accounts #1601 – 1604
AP Account – Bill Pay GL Account #2010
Purchase Receipts are received and approved in Aspire. When they come into your accounting system they are recorded as:
- Credit Accounts Payable - Aspire – GL Acct #2000
- Debit Inventory Holding - Aspire – GL Acct #1500
- Inventory Holding Material – GL Acct #1501
- Inventory Holding Equipment – GL Acct #1502
- Inventory Holding Sub – GL Acct #1503
- Inventory Holding Other – GL Acct #1504
- Reconcile Purchase Receipts from Task #3 from EOM Checklist
For Bill Pay, code:
- Debit – Inventory Holding – Bill Pay GL Accts # 1601 - 1604
- Credit – Accounts Payable – Bill Pay GL Acct #2010
At the end of the month, record a manual journal entry
- Record a journal entry and Use Purchase Receipt List #3 to see the dollar amount.
- Credit – Inventory Holding – Aspire GL Acct #’s 1500 - 1504
- Debit Accounts Payable – Aspire GL ACCT # 2000
- At the end of the month, in your Accounts Payable – Aspire GL Acct #2000 and Inventory Holding Accts – Aspire GL Acct #’s 1500 – 1504 should be zero.
EOM journal entry
This final EOM entry records the COGS and moves the inventory cost from the Bill Pay holding accounts to the COGS/Expense accounts:
Debit COGS Accounts by Division
Credit Inventory Holding – Bill Pay GL Acct #’s 1601 – 1604