AGRIS Customer Documentation

Utilization Of General Ledger Account Structure

DEFINITIONS:

Account Code: This is a four-digit to eight-digit code that is used to group like transactions together.

Detail Code (DTL): This is a code that can be up to four characters in length. This code can be numeric, alpha or alphanumeric. Using a detail code allows for greater detail within a given account to give management more detailed information for decision making purposes but also allows for financials to be “rolled-up” for reporting purpose to a board of directors, financial institutions and/or others who may need to see high level financial statements.

Profit Center Code (PFC): This is a three-character code which can be numeric, alpha or alphanumeric and is used to distinguish one department or enterprise from another at the same location. With multiple locations, like departments should have the same profit center code. This allows financial statements to be generated for a specific profit center at one location or for all locations. If using the Location Code to identify unique departments/enterprises then this code would not be use.

Location Code (LOC): This is a three-character system code that is set up under the maintenance Menu. This code controls several function areas with AGRIS. All transactions have at least one location code. A transaction can be created in one location on behalf of another location. Example: An invoice can be created in location A, this becomes the document location using inventory items from location B and this becomes the activity location. The sales and cost of sales will be posted to the ledger with location B on the transaction. This allows financial statements to be generated by location. The location code can be used to identify unique physical locations (i.e. towns) or to identify unique departments or enterprises. The one exception to this is that the administrative income and expenses should be in a unique location. This will allow them to be split to other locations and/or profit centers.

Account Structure: The account structure is the Account Code followed by the Detail Code followed by the Profit Center Code. The detail code and profit center code are not required and one can be used with out the other one.

 

Example: Three Locations and numerous detail codes. 100 series is administrative, 200 series is grain, 300 series is fertilizer, 400 is feed mill, 600 series is farm store, 700 series is convenience store

Location 100, 200 & 300 Detail Code

Administrative 100 (only used in location 100)

Wheat 210

Corn 220

Soybean 230

Liquid Fertilizer 310

Dry Fertilizer 320

Chemicals 330

Crop Production 340

Beef Feed 410

Dairy Feed 420

Swine Feed 430

Horse Feed 440

Unleaded 510

Ethanol 520

Farm Diesel 530

Road Diesel 540

Tires 610

Animal Health 620

Lawn& Garden 630

Groceries 710

Dairy 720

Auto 730

Candy 740

Beer 750

Tobacco 760

Example: Three Locations, Seven Profit Centers with numerous detail codes

 

Location 100 Profit Center Detail Codes

Administrative ADM

Grain Department GRN

Wheat 110

Corn 120

Soybean 130

Fertilizer Department FRT

Liquid Fertilizer 210

Dry Fertilizer 220

Chemicals 230

Feed Mill FDM

Dairy Feed 310

Beef Feed 320

Horse Feed 330

Swine Feed 340

Location 200

Grain Department GRN

Wheat 110

Corn 120

Soybeans 130

Bulk Fuel Department PTR

Unleaded 410

Ethanol 420

Clear Diesel 430

Dyed Diesel 440

Farm Store FST

Tires 510

Animal Health 520

Clothing 530

Lawn & Garden 540

Location 300

Grain Department GRN

Feed Mill FDM

Fertilizer Department FRT

C Store CST

Dairy 610

Fuel 620

Groceries 630

Auto 640

Candy 650

Beer 660

Tobacco 670

 

Below are two excerpts from a chart of accounts set up using the concept outlined above. The first excerpt is a portion of for the balance sheet accounts and the second excerpt is a portion of the income statement accounts.

 

Excerpt #1

1000 ASSETS FORMAT ... HEADING

1010 CURRENT ASSETS FORMAT ... HEADING.

1020 CASH TEXT ONLY

1020 01 CHECKING ACCOUNT POSTING

1020 03 SAVINGS ACCOUNT POSTING

1030 CASH ON HAND TEXT ONLY

1030 C1 CASH ON HAND - LOCATION 100 POSTING

1030 C2 CASH ON HAND - LOCATION 200 POSTING

1030 C3 CASH ON HAND - LOCATION 300 POSTING

1030 C9 CASH ON HAND - LOCATION 900 POSTING

1040 HEDGE ACCOUNT POSTING

1070 TOTAL CASH FORMAT ... TOTAL

1110 ACCOUNTS RECEIVABLE FORMAT ... HEADING

1120 TRADE RECEIVABLES POSTING

1125 CREDIT CARD RECEIVABLES POSTING

1130 EMPLOYEE RECEIVABLES POSTING

1140 NOTES RECEIVABLE POSTING

1150 GRAIN RECEIVABLES POSTING

1160 MISCELLANEOUS RECEIVABLES POSTING

1170 BGT BILL DELIVERED RECEIVABLES POSTING

1180 BGT BILL RECURRING RECEIVABLES POSTING

1190 TOTAL ACCOUNTS RECEIVABLE FORMAT ... TOTAL

1200 PREPAID EXPENSES FORMAT ... HEADING

1210 PREPAID EXPENSES POSTING

1220 PREPAID INSURANCE POSTING

1230 UTILITY DEPOSITS POSTING

1240 OTHER PREPAID EXPENSES POSTING

1270 TOTAL PREPAID EXPENSES FORMAT ... TOTAL.

1300 INVENTORY FORMAT ... HEADING.

1310 GRN GRAIN INVENTORY TEXT ONLY

1310 CN GRN CORN INVENTORY POSTING

1310 OT GRN OAT INVENTORY POSTING

1310 SB GRN SOYBEAN INVENTORY POSTING

1310 SG GRN MILO INVENTORY POSTING

1310 WW GRN WHEAT INVENTORY POSTING

1315 AGY CROP PRODUCTION INVENTORY TEXT ONLY

1315 A1 AGY LIQUID FERTILIZER INVENTORY POSTING

1315 A2 AGY DRY FERTILIZER INVENTORY POSTING

1315 A3 AGY ANHYDROUS INVENTORY POSTING

1315 A5 AGY LIQUID CHEMICAL INVENTORY POSTING

1315 A6 AGY DRY CHEMICAL INVENTORY POSTING

1320 FDM FEED INVENTORY TEXT ONLY

1320 F1 FDM BOVINE FEED INVENTORY POSTING

1320 F2 FDM EQUINE FEED INVENTORY POSTING

1320 F8 FDM FEED INGREDIENTS INVENTORY POSTING

1320 FF FDM MISCELLANEOUS FEED INVENTORY POSTING

1325 FST FARM STORE INVENTORY TEXT ONLY

1325 FS FST MISC FARM SUPPLIES INVENTORY POSTING

1325 G2 FST BUNKS & FEEDERS INVENTORY POSTING

1325 G3 FST STOCK TANK INVENTORY POSTING

1325 G5 FST GATES & PANELS INVENTORY POSTING

1325 G6 FST CHUTES INVENTORY POSTING

1325 GS FST SEED INVENTORY POSTING

1330 PET PETROLEUM INVENTORY TEXT ONLY

1330 N1 PET OIL & GREASE INVENTORY POSTING

1330 N3 PET TIRE & TUBE INVENTORY POSTING

1330 N5 PET TBA INVENTORY POSTING

1330 P1 PET UNLEADED AND ETHANOL INV POSTING

1330 P2 PET FARM DIESEL INVENTORY POSTING

1330 P3 PET ROAD DIESEL INVENTORY POSTING

1330 P5 PET PROPANE INVENTORY POSTING

1340 CST C-STORE INVENTORY TEXT ONLY

1340 S1 CST GROCERY INVENTORY POSTING

1340 S2 CST DELI INVENTORY POSTING

1340 S3 CST DAIRY INVENTORY POSTING

1340 S4 CST MERCHANDISE INVENTORY POSTING

1340 S5 CST BEVERAGE INVENTORY POSTING

1340 SA CST C-STORE TBA INVENTORY POSTING

1370 TOTAL INVENTORY FORMAT

 

 

Excerpt #2

4000 SALES FORMAT ... HEADING

4210 GRN GRAIN SALES TEXT ONLY

4210 CN GRN CORN SALES POSTING

4210 OT GRN OAT SALES POSTING

4210 SB GRN SOYBEAN SALES POSTING

4210 SG GRN MILO SALES POSTING

4210 WW GRN WHEAT SALES POSTING

4315 AGY CROP PRODUCTION SALES TEXT ONLY

4315 A1 AGY LIQUID FERTILIZER SALES POSTING

4315 A2 AGY DRY FERTILIZER SALES POSTING

4315 A3 AGY ANHYDROUS SALES POSTING

4315 A5 AGY LIQUID CHEMICAL SALES POSTING

4315 A6 AGY DRY CHEMICAL SALES POSTING

4320 FDM FEED SALES TEXT ONLY

4320 F1 FDM BEEF FEED SALES POSTING

4320 F2 FDM HORSE FEED SALES POSTING

4320 F8 FDM FEED INGREDIENT SALES POSTING

4320 FF FDM MISCELLANEOUS FEED SALES POSTING

4325 FST FARM STORE SALES TEXT ONLY

4325 FS FST MISC FARM SUIPPLIES SALES POSTING

4325 G2 FST BUNKS & FEEDERS SALES POSTING

4325 G3 FST STOCK TANK SALES POSTING

4325 G5 FST GATES & PANELS SALES POSTING

4325 G6 FST CHUTES SALES POSTING

4325 GS FST SEED SALES POSTING

4330 PET PETROLEUM SALES POSTING

4330 N1 PET OIL & GREASE SALES POSTING

4330 N3 PET TIRE SALES POSTING

4330 N5 PET TBA SALES POSTING

4330 P1 PET UNLEADED & ETHANOL SALES POSTING

4330 P2 PET FARM DIESEL SALES POSTING

4330 P3 PET ROAD DIESEL SALES POSTING

4330 P5 PET PROPANE SALES POSTING

4340 CST C-STORE SALES TEXT ONLY

4340 S1 CST GROCERY SALES POSTING

4340 S2 CST DELI SALES POSTING

4340 S3 CST DAIRY SALES POSTING

4340 S4 CST MERCHANDISE SALES POSTING

4340 S5 CST BEVERAGE SALES POSTING

4340 SA CST C-STORE TBA SALES POSTING

4490 TOTAL SALES FORMAT ... TOTAL

4580 OTHER REVENUE FORMAT ... HEADING

4610 FREIGHT INCOME TEXT ONLY

4610 FDM FREIGHT - FEEDMILL POSTING

4610 CN GRN FREIGHT - CORN POSTING

4610 SB GRN FREIGHT - SOYBEANS POSTING

4610 SG GRN FREIGHT - MILO POSTING

4610 WW GRN FREIGHT - WHEAT POSTING

4630 GRN DRYING INCOME TEXT ONLY

4630 CN GRN DRYING CHARGE - CORN POSTING

4630 SB GRN DRYING CHARGE - SOYBEANS POSTING

4630 SG GRN DRYING CHARGE - MILO POSTING

4630 WW GRN DRYING CHARGE - WHEAT POSTING

4650 GRN STORAGE INCOME TEXT ONLY

4650 CN GRN STORAGE - CORN POSTING

4650 SB GRN STORAGE - SOYBEANS POSTING

4650 SG GRN STORAGE - MILO POSTING

4650 WW GRN STORAGE - WHEAT POSTING

4670 GRN D.P. REVENUE TEXT ONLY

4670 CN GRN D.P. REVENUE - CORN POSTING

4670 SB GRN D.P. REVENUE - SOYBEANS POSTING

4670 SG GRN D.P. REVENUE - MILO POSTING

4670 WW GRN D.P. REVENUE - WHEAT POSTING

4710 AGY CROP PRODUCTION SERVICES POSTING

4730 FDM FEEDMILL SERVICES REVENUE POSTING

4750 PET PETROLEUM SERVICES INCOME POSTING

4770 TOTAL OTHER REVENUE FORMAT ... TOTAL

4799 GROSS SALES

 

Below is an excerpt from a balance sheet report at the account code level, note the inventory accounts. Because this is a condensed version, this balance sheet can be shared with third parties and board members.

 

 

DATE: 06/09/11 AG SUPPLY COOPERATIVE PAGE: 1
TIME: 5:49 pm Balance Sheet - Current Only

 

CUR YTD 11/30/08

 

CURR YTD

ACCOUNT DESCRIPTION AMOUNT

---------------------------------------------------------------------------------------------------------------------

ASSETS

CURRENT ASSETS

CASH 17,500.00

CASH ON HAND 56,260.00

HEDGE ACCOUNT 31,500.00

--------------

TOTAL CASH 105,260.00

 

ACCOUNTS RECEIVABLE

TRADE RECEIVABLES 1,260.00

CREDIT CARD RECEIVABLES 2,500.00

BGT BILL DELIVERED RECEIVABLES 500.00-

--------------

TOTAL ACCOUNTS RECEIVABLE 3,260.00

 

PREPAID EXPENSES

PREPAID EXPENSES 56,400.00

PREPAID INSURANCE 9,400.00-

UTILITY DEPOSITS 500.00

--------------

TOTAL PREPAID EXPENSES 47,500.00

INVENTORY

GRAIN INVENTORY 83,540.00-

CROP PRODUCTION INVENTORY 52,550.00

FEED INVENTORY 19,668.10

FARM STORE INVENTORY 46,550.00

PETROLEUM INVENTORY 181,400.00

--------------

TOTAL INVENTORY 216,628.10

--------------

TOTAL CURRENT ASSETS 372,648.10

 

 

Below is an excerpt of a balance sheet report at the detail code level, again note the inventory accounts. Because this balance sheet contains more information it is very useful for management.

 

 

DATE: 06/09/11 AG SUPPLY COOPERATIVE PAGE: 1

TIME: 5:56 pm Balance Sheet - Current Only

 

CUR YTD 11/30/08

 

CURR YTD

ACCOUNT DESCRIPTION AMOUNT

------------------------------------------------------------------------------------------------------------------------

ASSETS

CURRENT ASSETS

CHECKING ACCOUNT 12,500.00

SAVINGS ACCOUNT 5,000.00

CASH ON HAND - LOCATION 100 25,660.00

CASH ON HAND - LOCATION 200 150.00

CASH ON HAND - LOCATION 300 300.00

CASH ON HAND - LOCATION 900 150.00

HEDGE ACCOUNT 31,500.00

--------------

TOTAL CASH 105,260.00

 

ACCOUNTS RECEIVABLE

TRADE RECEIVABLES 1,260.00

CREDIT CARD RECEIVABLES 2,500.00

BGT BILL DELIVERED RECEIVABLES 500.00-

--------------

TOTAL ACCOUNTS RECEIVABLE 3,260.00

 

PREPAID EXPENSES

PREPAID EXPENSES 56,400.00

PREPAID INSURANCE 9,400.00-

UTILITY DEPOSITS 500.00

--------------

TOTAL PREPAID EXPENSES 47,500.00

INVENTORY

CORN INVENTORY 30,500.00-

OAT INVENTORY 9,625.00-

MILO INVENTORY 15,290.00-

WHEAT INVENTORY 28,125.00-

LIQUID FERTILIZER INVENTORY 17,500.00

DRY FERTILIZER INVENTORY 7,800.00

ANHYDROUS INVENTORY 15,000.00

LIQUID CHEMICAL INVENTORY 7,250.00

DRY CHEMICAL INVENTORY 5,000.00

BOVINE FEED INVENTORY 3,000.00

EQUINE FEED INVENTORY 2,500.00

FEED INGREDIENTS INVENTORY 12,368.10

MISCELLANEOUS FEED INVENTORY 1,800.00

MISC FARM SUPPLIES INVENTORY 15,000.00

BUNKS & FEEDERS INVENTORY 5,000.00

STOCK TANK INVENTORY 3,500.00

GATES & PANELS INVENTORY 3,550.00

CHUTES INVENTORY 8,000.00

SEED INVENTORY 11,500.00

OIL & GREASE INVENTORY 3,000.00

TIRE & TUBE INVENTORY 8,000.00

TBA INVENTORY 1,500.00

UNLEADED AND ETHANOL INVENTORY 55,000.00

FARM DIESEL INVENTORY 37,500.00

ROAD DIESEL INVENTORY 26,000.00

PROPANE INVENTORY 50,400.00

--------------

TOTAL INVENTORY 216,628.10
--------------

TOTAL CURRENT ASSETS 372,648.10

 

 

Administrative Splits: To utilize Administrative Splits, all administrative expenses must be in one location code. This can be a separate location code or if you use Profit Centers, the administrative expenses can be in a unique Profit Center.

 

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.