Pak Accounting has the ability to set up a Sub-Account as an allocation for transactions (ie. Journal entries, invoices). Any place a Sub-Account can be coded (A/P Entry, Unposted Entries, Payroll, DOI, etc), a pound Sub-Account can be used instead. Once an entry with a “#” Sub-Account is posted, the entry is allocated out to the various Sub-Accounts based on how the allocation is setup (Allocation Master Maintenance).

Set up a pound allocation Sub-Account in Sub-Account Maintenance [F12]

1. Click Add and enter in the Sub-Table for the item to be allocated (for example, if allocating lease and well expenses, use Sub-Table 50). The Sub-Account must start with a # sign. The name will be the full name of the allocation. Click Save.
   In the example below, I'm creating allocation #TXALL for all of my properties in Texas.
   
2. Once saved, click on the #Alloc button in the lower right-hand corner of the screen (see screenshot above). If you do not see this option, then the Sub-Account code was not set up correctly; make sure it begins with the # sign. This will open up the Sub-Account #Allocation Maintenance window. (See the example in the screenshot below:
   
   NOTE: Most allocations are set up on a percent basis, where each Sub-Account gets a set percentage of the total amount being allocated.
3. Add the individual items that should be included in the allocation. Click on the plus button at the bottom and add the Sub-Accounts to which the entry will be allocated (the Sub-Accounts must already be set up in the Sub-Table indicated). See the table below for information on setting up the individual fields.
4. Once the allocation is set up, you are ready to enter entries that use the pound allocation Sub-Account (A/P entries, journal entries, Payroll, DOI, Check Stub, etc).
   1. Upon posting the invoice, the allocation is generated, and the entries are posted to the individual Sub-Accounts as defined in the pound allocation. These can be seen in View/Trend and in other reports.
   2. Deleted Interest may be used with this feature only if all properties have the same deleted interest percentage.

The List button allows you to print the Allocation Master Listing for selected Sub-Tables, Allocation IDs, and certain effective dates. The File button under the list allows you to export the pound allocation as an XLSX, XLS, or CSV file.

Example 1: EXACT MATCH. We need to set up a Master Meter for Williams Field. The percentages for this meter change each month, so we will set it up as an Exact Match so we can enter the MCF volume breakout for each production period.

1. In the General Ledger module > Sub-Account Maintenance (F12), the Master Meter is set up as Sub-Account #MMWIL in Sub-Table 50.
2. We need to add a screen for May 2024, so enter 05/2024 in the view date. Since an allocation doesn't exist for this date yet, there will be a box at the bottom that says Create new set as of 05/2024. Click on this button.
   NOTE: Be careful when looking at the dates. The View Date will default to the month/year you are currently in since the system assumes you are going to create a new date-specific allocation. However, the date you are truly in will show just below.
   
   A popup will appear asking if we want to copy the Allocation from the previous period. In this case, the date is 01/1980, click Yes.
   
   We now have an allocation for May 2024 that we can work with. Enter the MCF breakout for this period, and click Save.
   
3. Set up Check Stub > Division Order: the Division Order for the Williams Master Meter using the Purchaser’s property #. The “Send Entries to” Property # is our new #MMWIL. If the NRI doesn't default to 1.0000000, change it so that it does. Don't worry that the NRI is red; this is because the #alloc is not set up in the Rev/Bill DOI but in the individual properties.
   
4. Once the Division Order has been created, look at our entries in Check Stub > Enter Deposits/Stub from Taurus (the Purchaser). Notice the volumes entered match the #ALLOC setup.
   
5. After posting the Check Stub, we can look at the entries in View/Trend. We can see how the sales (red) and the taxes (blue) were broken out according to the #ALLOC setup.

Example #2 - FIXED We are going to set up an allocation for our Oklahoma properties. The volumes change each month; however, the percentages assigned to each property do not change. So, we are going to set up a Fixed (No-Date) allocation.

1. In the General Ledger module > Sub-Account Maintenance [F12], set up Sub-Account #OKALL in Sub-Table 50.
2. Check the Fixed box and enter the properties. The Factor will populate the Computed Pct fields.
   
3. Since we showed an example in the Check Stub, let's use Account Payable this time. Enter an A/P entry via the Accounts Payable Menu > Enter Invoices to Pay, and post the invoice.
   
4. After posting the invoice,, we can look at the entries in View/Trend. We can see how the billing account was divided according to the #ALLOC setup.
   

Example #3: Using the Token field.

NOTE: Pak Accounting provides the ability to import from Excel. Click on the #Alloc button by the Menu button and then click on the Utilities button > Import Set to see the import format. Required Header Columns are AllocID, Sub-Table, and DateOpt. Optional Header Columns: AllocName, BasisTitle, TokenTitle, BasisNDec. Optional Detail Columns: EffDate, Property, DeckNum, AFENumber, AFEStage, Basis, Token.