Category Type: Sublet



This type of Category is assigned to Sublets that are used in Blackpurl - if you are unsure what a sublet is, please review this article - What is a Sublet / How to Setup a Sublet


You would also use this Category Type for Warranty Plans and Deal Options but in this article we are covering off Sublets:


This Sublet Category is setup as follows:



Let's discuss what these fields are:


Name - Just the name of this Sublet Type Category 


Income GL - This is the Income General Ledger account where the income from selling a Sublet will integrate to, in your accounting package


COGS GL  - This is the COGS General Ledger account where the income from selling a Sublet will integrate to, in your accounting package


Inventory GL - While we never keep a running inventory value for Sublets, we do indicate an Sublet Accrual General Ledger account that is used as a clearing account to make sure that all Sublets are accounted for. You would need to indicate a liability General Account which would be a true clearing account


How to use this Sublet Category


This Vendor: Smith & Co has a few sublets setup and they have been assigned the Sublet Category: Sublet Sales 



This means that when one of the Vendor: Smith & Co Sublets are processed in Blackpurl then there will be several transaction that will integrate from Blackpurl to your accounting package.  Examples are:

  • when a VR (Vendor receiving) for a sublet is processed - a journal transaction will integrate from Blackpurl to your accounting package 
  • when a VI (Vendor invoicing) for a sublet is processed - a Vendor Invoice document will integrate from Blackpurl to your accounting package 
  • when a Customer Order is finalised and it has a Sublet - a journal transaction will integrate from Blackpurl to your accounting package

How these transaction integration to your accounting package and what General Ledger accounts they integrate to is set by what has been setup on the relevant Sublet Category


When a VR for a sublet is processed in Blackpurl, a journal integrates to your accounting package as:

Debit - BP Sublet Accrual General Ledger - as what is setup on the relevant Sublet Category for the Inventory GL field 

Credit - Received Inventory Accrual General Ledger.  It will remain in this clearing account until the VI is processed

Here is an example:

When the VI for a Sublet is processed in Blackpurl, a transaction will integrate to your accounting package as: 

The Vendor Invoice document will be created with the offset General Ledger being your Received Inventory Accrual General Ledger  


Received Inventory Accrual General Ledger  

This will then balance out your Received Inventory Accrual General Ledger for the VR and VI transactions

BP Sublet Accrual General Ledger / Income / COGS entries

  • Left over from the VR journal, there is still an amount sitting in the BP Sublet accrual waiting for the relevant Sublet to be invoiced out through the Customer Order in Blackpurl
  • Once the Customer Invoice in Blackpurl is finalised, the invoice will integrate over to your accounting package:


The Customer Invoice document will be created in your accounting package with the offset General Ledger being your Income General Ledger (as per the General Ledger indicated in the Income GL field on the relevant Sublet Category) 

 

  • A journal will also integrated that will clear the BP Sublet Accrual General Ledger and the offset will be to the COGS General Ledger (as per the General Ledger indicated in the COGS GL field on the relevant Sublet Category) 

 


This transaction has now balanced out the VR transaction to BP Sublet Accrual General Ledger for that relevant Sublet 


**Warranty Plans and Deal Products will also be assigned with a Category Type: Sublet.  We would suggest that you setup new Categories for Warranty Plans and Deal Products with the relevant General Ledgers