Managing Core Charges

Simple Method

WinNetStar provides for an option to mark up your core charges. In this example we are selling an inventory item with a manufacturer core charge of $150.00 that has been marked up through the pricing source to $180.00.

The Transaction Detail Report (Reports>Financial>Transaction Detail Report) shows the accounting entries associated with this invoice. We can see that the sale of a core produces a credit to the revenue account associated with the respective Inventory Item. The debit to COGS in the amount of $253.56 includes the $150.00 cost of the core so there is a profit of $30.00 related to the core. If the customer never returns the dirty core, the accounting for this transaction is complete. The following screen shots illustrate the accounting associated with the return of the core by the customer and the processes associated with sending dirty cores back to the manufacturer for credit.

The process for return of a core at point of sale is as follows:

1 – Open a new Invoice and select the Customer

2 – Click on Apply Core Credits (or hit the F5 key on your keyboard) to produce the Eligible Cores pop up. This pop up will display all cores eligible to be returned by the customer selected.

3 – Click in the box on the left margin of the pop up for all cores being returned and click on the OK button. This will add the core credits to the Invoice and, when the Invoice is settled, will remove the core from the Eligible Core list for this customer.

The core now shows as a credit on the customer’s invoice. See next page for related accounting entries that occur when this transaction is finalized.

The Transaction Detail Report displays the accounting entries associated with the return of the core. The original revenue amount of $180.00 is reversed with a debit. The original cost of goods sold amount of $150.00 is reversed with a credit. And the $150.00 cost of the dirty core is recorded in the Dirty Core Inventory account.

The Dirty Core Inventory account is used by the system when cores are purchased back from customers. Double click on this line in your Chart of Accounts to open the Transaction Register for this account.

The last line shows the debit for $150.00 for the core purchased in our example. Note that the part number is included in the reference column.

In this example, the core credits on the month end statement from the manufacturer totaled $1468.00. The entry debits the accounts payable account for that manufacturer and credits dirty core inventory. This removes the cores from your dirty core inventory account and sets up the manufacturer credit in accounts payable to be used when the statement is paid. This entry is being made after you receive the statement from your manufacturer showing the credits they are giving you for dirty cores.

If you are using the Simple Method, your core processing is complete.

Specific Identification Method

Step 1

This is the transaction register for the dirty core inventory account. To open this register, double click on the dirty core inventory account in your chart of accounts. Then filter the list to display only those entries that have not been reconciled. If you are following the Specific Method procedures, this should be a list of your dirty cores on hand. Print this list and have the Parts Department check off each item that they will be including in the shipment to the manufacturer. You will enter a Journal Entry for the sum of the dollar value of those items in the shipment (debit accounts payable and credit dirty core inventory) and then perform a reconciliation of the dirty core inventory account. See next pages for example of journal entry and reconciliation.

Step 2

In this example, the sum of the dirty cores included in the shipment, as provided by the parts department, totals $1,631.50. Just like in the Simple Method, we will make an entry to set up the manufacturer credit in accounts payable and relieve our dirty core inventory account. The main difference here is that this entry is being made at the time of the shipment based on a list provided by the parts department. If you wish, you can scan the list from the parts department and attach the image to this JE so that you have supporting documentation for this entry to be used for comparison to the actual credit issued by the manufacturer on the monthly statement.

Step 3

After each shipment and resulting Journal Entry, you will perform a reconciliation of the Dirty Core Inventory Account. Navigate to Banking>New>Reconciliation. On the account drop down, select the appropriate Dirty Core Inventory account for your location. Check all the boxes in the left hand margin corresponding to all of the dirty cores included in the shipment and check the box corresponding to the Journal Entry related to that shipment. The sum of the Net Activity in the top section of this screen will equal zero when you have all appropriate items checked. You can then click on Save Finished Reconciliation.

Step 4

If you are using the Specific Identification Method, the expected credit that you set up from the manufacturer may ultimately be different than the actual credit provided by the manufacturer so you will need to reconcile those when you receive your statement and make any necessary adjustments to those credits. If you have attached a scanned image of the detail of items shipped to each shipment Journal Entry (as suggested in Step 2 above), this reconciliation process will be much easier.

Step 5

Using the Specific Identification Method still requires the periodic verification of on hand quantities compared to system quantities. But if you are using this method, you can print a detail list of on hand quantities (like we did in step 1 above) to facilitate the counting process.

Variances found in the count can be adjusted using a Journal Entry as seen above. If you are writing down your dirty core inventory account due to missing cores, you should immediately perform another reconciliation within the system (as we did in step 3) to check off this Journal Entry and the corresponding missing cores so that you will be able to produce an accurate list of cores on hand as we did in step 1.

This concludes the Specific Identification Method.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us