Click to leave your feedback on the Help system.

Transaction Assignments

This section describes the transaction assignment process and includes the following subsections:

What are Transaction Assignments

This form allows to map different C-Store Office activities (data types) to the general ledger (GL) of accounts. Every transaction added to C-Store Office MUST be assigned to two GL accounts. One account must be debited and other must be credited. For example, “Gasoline Sales” credits the Sales-Gasoline account and debits the Cash on Hand account. Sales made by credit card will credit the Cash on Hand account and debit the AR Credit Cards account.

Transaction assignment is preset if the user chooses to accept the C-Store Office Chart of accounts.  However, if chart of accounts is changed, remember to check transaction assignments to make sure there are no unassigned system activities (data types) left. If custom chart of accounts is created, all transaction assignments must be done manually. In this case the chart of accounts must be created first and only then should the user do transaction assignments. If some accounts are missing in this process, come back to the chart of accounts and create additional accounts.

Opening Transactions Assignment Form

To open the Transactions Assignment form, go to Settings > Company > Transaction Assignment.

Assigning Transaction

To assign a transaction, follow the steps:

  1. Open the Transactions Assignment form. For details, see Opening Transactions Assignment Form.
  2. Scroll the form down till the first empty string.
  3. For each assigning transaction, select the next empty string and specify the following data:
  4. Make sure the Data Type column contains the required data type. If no, do the following:
  5. At the bottom of the Transactions Assignment form, click the Required Datatypes button.
  6. In the opened Data Type form, select the data type you need to add.
  7. At the top of the Data Type form, click the Save button.

  8. In the Data Type column, select the data type for assigning.
  9. In the Debit Account column, select the account you want to debit.
  10. In the Credit Account column, select the account you want to credit.
  11. At the bottom of the form, click Save.

In case you need to backdate the transaction data, use the Data Converter Tool. For details, see Working with the Data Converter Tool.

ClosedExample: List of Transaction Assignment

Data Type

Credit Account

Debit Account

Buydown By Purchases/Purchases

9203.1 Store:Purchases-Store

Accounts receivable:Buy-downs(S)

Buydown By Sales

9106 Sales-Store

Accounts receivable:Buy-downs(S)

Cash Register/ATM

Cash on Hand(S)

AR ATM (S)

Cash Register/Cash

Cash on Hand(S)

Undeposited Funds (S)

Cash Register/Coupons

Cash on Hand(S)

Coupons(S)

Cash Register/Credit Cards

Cash on Hand(S)

Credit Cards (S)

Cash Register/FS

Cash on Hand(S)

AR FS (S)

Cash Register/House Account

Cash on Hand(S)

House Accounts(S)

Cash Register/Lottery Cash

Cash on Hand(S)

Undeposited Funds (S)

Cash Register/Other Cards

Cash on Hand(S)

Credit Cards (S)

Custom Income Sales

9106 Sales-Store

Cash on Hand(S)

Diesel Inventory Beginning

Diesel Inventory(S)

9202.2 Diesel:Purchases-Diesel

Diesel Inventory Ending

9202.2 Diesel:Purchases-Diesel

Diesel Inventory(S)

Diesel Purchases

AP Gasoline Purchases (S)

9202.2 Diesel:Purchases-Diesel

Diesel Sales

9105 Sales-Diesel

Cash on Hand(S)

Expenses/Cash

Cash on Hand(S)

9999 Suspense

Gasoline Inventory Beginning

Gasoline Inventory(S)

9200.1 Gasoline:Purchases-Gas

Gasoline Inventory Ending

9200.1 Gasoline:Purchases-Gas

Gasoline Inventory(S)

Gasoline Purchases

AP Gasoline Purchases (S)

9200.1 Gasoline:Purchases-Gas

Gasoline Sales

9103 Sales-Gasoline

Cash on Hand(S)

Instant Lottery Purchases

AP Instant Lottery(S)

Instant Tickets Inventory(S)

Instant Lottery Sales

Instant Tickets Inventory(S)

Cash on Hand(S)

Instant Lottery Shorts

9306.3 Cash Shortages:Lottery inventory shortage

Instant Tickets Inventory(S)

Kerosene Inventory Beginning

Kerosene Inventory(S)

9201.1 Kerosene:Purchases-Kerosene

Kerosene Inventory Ending

9201.1 Kerosene:Purchases-Kerosene

Kerosene Inventory(S)

Kerosene Purchases

AP Gasoline Purchases (S)

9201.1 Kerosene:Purchases-Kerosene

Kerosene Sales

9104 Sales-Kerosene

Cash on Hand(S)

Lottery Paidouts

Cash on Hand(S)

AP Instant Lottery(S)

Merchandise Addition Cash

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Merchandise Addition Cash By Category

Cash on Hand(S)

9203.1 Store:Purchases-Store

Merchandise Addition Check

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Merchandise Addition Check By Category

Store Bank (S)

AP Store Purchases (S)

Merchandise Addition Check By Category

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Merchandise Addition Credit

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Merchandise Addition Credit By Category

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Online Lottery Sales

AP OnLine Lottery(S)

Cash on Hand(S)

Paid Out/Cash

Cash on Hand(S)

AP Store Purchases (S)

Paid Out/Check

Store Bank (S)

AP Store Purchases (S)

Paid Out/Credit

AP Store Purchases (S)

9203.1 Store:Purchases-Store

Store Inventory Beginning

Store Inventory(S)

9203.1 Store:Purchases-Store

Store Inventory Ending

9203.1 Store:Purchases-Store

Store Inventory(S)

Store Sales

9106 Sales-Store

Cash on Hand(S)

Store Sales Taxes

AP Sales Tax (S)

Cash on Hand(S)

Sunoco Gifts

AP Gasoline Purchases (S)

9203.1 Store:Purchases-Store

Transaction Assignments Training

 

Last updated: Tuesday, November 6, 2018
Copyright © Petrosoft, LLC
Confidentiality level – Public use Petrosoft, LLC
  290 Bilmar Drive, Pittsburgh, PA 15205
  Phone: 412-306-0640
  Fax: 412-202-5487
Feedback