1. For the new SGL - in the 'Other Codes' column there is a notation of 'Reverse Sign'. Does this mean what we call the offset, or is it 'the other side of the journal entry'? Could you please provide an example of how this works (possibly using BSC 1691, OB, FT=WA)? (Date posted – 2/10/04)
A. The notation reverse sign means that the SGL account will be generated with a sign opposite the Balance Sheet Account that created it.
BSC 1691 account with a summary class of OB and fund-type WA would generate three entries using the crosswalk. Assume a debit balance of $100:
- 1691, SCC= All, Fund Type not equal 5* and status code not equal 3 or 4 would generate an SGL 1511B1 for a debit $100
- 1691, SCC = OB, 01, Fund Type not equal 1*, 2*, 3*, 5*, VE, VP would generate an SGL 310000 for a debit $100
- 1691, SCC = OB, 01, Fund Type not equal 1*, 2*, 3*, 5*, VE, VP and Reverse sign, would generate an SGL 331009 for a credit $100.
The other credit leg of the entry would be generated from a different balance sheet code.
2. What SGL will BSC 8133 equal to 5X be crossed to? The current table shows 8133 not equal to 5X. How will capital purchases be recorded in STARS? Date posted – 4/06/04)
A. As an example, using fund type 51 equipment, capital purchases in STARS would be recorded as follows:
DR 88020100 TC (BSC 8133 TC)
CR 88010100 TC (BSC 8133 TC Reverse Sign)
DR 17200100 TC (BSC 2311 51)
CR 2190B600 TC (BSC 3141 TC)
DR 57000000 TC (BSC 8133 TC Reverse Sign)
CR 31070900 TC (BSC 8133 51 Reverse Sign)
To Capitalize
DR 17120000, 17300000, 17400000, 17500000 TC (BSC 2150 51)
(SGL account depends on asset type)
CR 17200100 TC (BSC 2311 51)
3. Before passing data to DOE we ensure that all WFO data zeros by fund type under the formula:
Accounts Receivable (BSC 14XX) + Revenue (BSC 8132/ B&Rs beginning ZN, 70, 75, or 50) + Collections (BSC 4XXX) + Advances (BSC 3XXX) = 0
When we run this formula under the new SGL codes it appears that there are balances under Fund types 2Y, 2T, and 3Y - is this correct? (Date posted – 4/20/04)
A. We are not crosswalking 4811 or 4812; instead, we are crosswalking a debit and a credit from the "other leg" of the transaction with the detailed order number information.
For example, using current year data 2Y is in balance. The accounts and balances for the SGL version of this balancing edit are below:
| From BSC SGL |
Amount |
3913 21 101002
(or 101000 with SCC 21) |
$1,258,757.28 dr (cash collected) |
| 3913 21 231019 |
1,258,757.28 cr (advance collected) |
| 3911 60 231039 |
56.08 cr |
| 3913 60 231039 |
1,431,459.43 dr
net 231039 = $1,431,403,35 dr
(advance used) |
| 8132 rev. 520009 |
1,431,403.35 cr (revenue) |
| Edit total |
$ 0.00 |
Funds 3T and 3Y would include accounts receivable 1310RB and 1310RD. Cash account 101002, in addition to advances from 3912, would pick up 1441 collections. Currently, we have collections booked with SCC 19 and 21 for reimbursable work.
4. What is the SGL for the legacy BSC 8133, Fund Type 51 records for work in progress costs? (Date posted – 4/20/04)
A.
| Current Entries |
SGL-STARS Entries |
| Fund Type TP |
Fund Type TP |
| 8133 SCC 60 |
172001 (From 2311) |
| 3xxx |
172002 (From 2312) |
| |
880201 (From 8133 SCC 60) |
| |
880101 (From 8133 SCC 60) |
| |
671000 (From 8132 offsetting 2312) |
| |
2110xx (From 3xxx) |
| Fund Type 51 |
|
2311 61
2312 60
8133 61 |
|
5. Please assist with crosswalk to the SGL table for this Old Entry:
BSC Summary Class Fund Type Amount
1441 19 3T 100.00
Can you tell us what the new SGL accounting would be? We thought it went to 1310RB00, but what about 10100200 with the "reverse sign". Both SGLs fit the description. Does this actually generate two entries, when we use to have only one? (Date posted – 2/10/04)
A. You would need to generate both the 1310RB00 and the 10100200 entry (reverse sign) from the current balance sheet code 1441 with a Summary Class Code 19. These SGL codes represent the collection of a receivable (1310RB00) and the cash collected 10100200. Under the current system the cash entry is recorded on the field offices books but in STARS and SGL your site will have to make both sides of the entry.
6. BSC Status Fund Type Summary Class
1691 01 TC 25
Please distinguish when to use SGL 1511B1 880103 and 880203. It appears from the crosswalk that 1511B1 and 88203 could be one in the same. (Date posted – 4/06/04)
A. The recording of a BSC 1691 with a summary class code of 25 reflects the purchase of stores inventory. In SGL when an inventory or fixed asset is purchased we must hit the asset account (In this case 1511B100) and a 8801xx a 8802xx account. The 8801 and 8802 are only hit during an asset purchase and not when inventories are reduced. The 1511B1 account would be hit anytime the inventory balance changes while the 8801 and 8802 would be hit only for a purchase.
