20160916PR #13 Batch #1352899.pdf

I i
Journal • Journal Entry
QK Qelete cancel form Row Iools
~ CJ IS lit
Batch Number
Doc Type/No/Co
Explanation
Rijt:ords 1 ~ 7
D llli Account Number*
D
D
D
D
D
D
D
(
48.1420.13101
48.1442.300
48514.5630.29030
48.1420.13101
48.1420.13101
48.1432.0910
11352899
/48 Je12-99 Conversion entry
Amount Remark
65,455.58 Conversion c/o due to Jes in C
65,455.58-Conversion c/o due to Jes in C
5,371.39 Conversion c/o due to Jes in C
6,371.39-Conversion c/o due to Jes in C
4,776.41 Conversion c/o due to Jes in C
4,776.41-Conversion c/o due to Jes in C
-------~ 1Sb03, x
[00048
Subledger
DModel OPercent
G/L Date
Ledger Type
Remaining Amount
Subledger Account
Type Description
Customer NR -Cyclical
Current Year Recoveries
Customer Records & Collect.
Customer NR -Cyclical
Customer NR -Cyclical
CIS To NR Clearing Account
112131/2015 ---
[AA -~---
Subledger
Description
DReverse
Address
Number
Receipt
Number
)
48 Je12-99 Conversion entry
December-15
Account Number
48.1420.13101
48.1442.300
48514.5630.29030
48.1420.13101
48.1420.13101
41}1,1432.0910
Audit: s/b zero
0.00
Amount Remarks
65,455.58 Conversion c/o due to Jes in CW
-65,455.58 Conversion c/o due to Jes in CW
5,371.39 Conversion c/o due to Jes in CW
-5,371.39 Conversion c/o due to Jes in CW
4,776.41 Conversion c/o due to Jes in CW
-4,776.41 Conversion c/o due to Jes in CW
Tool: Import Grid Data: make sure Jde is default
Excel file: F:\DATA\SS\CONVERTD\lcfo import.xlsx
Worksheet Name: JE99
Range: A9:C?
Apply
Continue
To Je CCB conversion balance not carryover to ccb (1442.300). See BU.
To Je CCB conversion balance not carryover to ccb (1442.300). See BU.
To Je CCB conversion balance not carryover to ccb (1442.300). See BU.
To Je CCB conversion balance not carryover to ccb (1442.300). See BU.
To Je CCB conversion balance not carryover to ccb (1432.0910). See BU.
To Je CCB conversion balance not carryover to ccb (1432.0910). See BU.
Batch number:
Entered By:
Approved By:
Date approved: \2-· 3b ·· 'Ir;,
13101 Balance:
64.860.60
110K11
Cl1759 SA Balance by GL Account
DataSource: PRODREPORTS -PRDRPT
Input parameters: CIS Division(s): IGCID,As of Date: 07-28-2015
Company Balances as of 28-July-2015
Company: lntermountain Gas
GL Account: IGC ACCOUNTS RECEIVABLE -LARGE VOLUME
Service Type
Gas Service
Gas Service
Gas Transportation Service
Agreement Type
GAS-LARGE COMMERCIAL
GAS-LV INDUSTRIAL
GAS-LV TRANSPORTATION
IGC ACCOUNTS RECEIVABLE -LARGE VOLUME Total
GL Account: IGC ACCOUNTS RECEIVABLE-GAS UTILITY
Service Type Agreement Type
Gas Service GAS INTERRUPTIBLE RES-SNWML T
Gas Service GAS INTERRUPTIBLE COM-SNWML T
Gas Service GAS-FIRM COMMERCIAL
Gas Service GAS-IRRIGATION/WATER PUMPING
Gas Service GAS-RESIDENTIAL
IGC ACCOUNTS RECEIVABLE-GAS UTILITY Total
GL Account: IGC ACCOUNTS RECEIVABLE-MISAPPLIED UNIVERSAL PAYMENT
Service Type Agreement Type
Gas Service PAYMENTS IN SUSPENSE
IGC ACCOUNTS RECEIVABLE-MISAPPLIED UNIVERSAL PAYMENT Total
GL Account: IGC CUSTOMER DEPOSITS
Service Type
Deposit Install Bill
Deposit Install Bill
Deposit Install Bill
Agreement Type
CUSTOMERDEPOSIT-COMMERC~L
CUSTOMER DEPOSIT -LARGE VOLUME
CUSTOMER DEPOSIT -RESIDENTIAL
IGC CUSTOMER DEPOSITS Total
GL Account: IGC KEEP KIDS WARM DONATIONS
Service Type Agreement Type
Non-Utility KEEP KIDS WARM PLEDGED
IGC KEEP KIDS WARM DONATIONS Total
Page 1 of 91
Print Date: 08/01/2015 at 1: 11 am
Data Date: 08/01/2015 at 12:41 am
Current Balance
20,896.43
17,141.74
22,207.20
60,245.37
Current Balance
378.23
10.24
1,100,412.28
9,451.43
661,535.94
1,771,788.12
Current Balance
(4,776.41)
(4,776.41)
Current Balance
3,724.25
0.00
55,155.43
58,879.68
Current Balance
0.00
0.00
Total Balance
20,896.43
17,141.74
22,207.20
60,245.37
Total Balance
378.23
10.24
967,287.97
9,451.43
(2,999,134.76)
(2,022,006.89)
Total Balance
(4,776.41)
(4,776.41)
Total Balance
(211,495.99)
(1,172.00)
(594,256.73)
(806,924.72)
Total Balance
0.00
0.00
Report: Cl1759
Audit Repo_rt & GL balances: should be zero
New for Je correction: 12/17/2015
Cl1759 current month: -15,374.35
Reports & Jde Feed bal:
Previous month ending bal: 0.00
Jde current true balanc, -15,374.35 ==========;::;:=:;;:;;:;;;;:::;;::;:I Jde current end of mo E -10,597.94
Note: Cl1790A is check to Jde monthly control master
current month.
,4i't6:41 C '<'" /) c1 ( 7)
nv t?))r
Cl1759
D~aSo~~e:P~OD~EPORTS-PRDRPT
SA Balance by GL Account
Input parameters: CIS Division(s): IGCID,As of Date: 08-31-2015
Company Balances as of 31-August-2015
Company: lntermountain Gas
GL Account: IGC ACCOUNTS RECEIVABLE -LARGE VOLUME
Service Type
Gas Service
Gas Service
Gas Transportation Service
Agreement Type
GAS-LARGE COMMERCIAL
GAS-LV INDUSTRIAL
GAS-LV TRANSPORTATION
IGC ACCOUNTS RECEIVABLE· LARGE VOLUME Total
GL Account: IGC ACCOUNTS RECEIVABLE-GAS UTILITY
Service Type Agreement Type
Gas Payment Arrangement PAYMENT ARRANGEMENT-GAS REGULATED
Gas Service CREDIT BALANCE REFUND ACCT FOR OVERPMTS AND
Gas Service GAS INTERRUPTIBLE RES-SNWMLT
Gas Service GAS INTERRUPTIBLE COM-SNWML T
Gas Service GAS-COMPANY USE
Gas Service GAS-COMPRESSED NATURAL GAS
Gas Service GAS-FIRM COMMERCIAL
Gas Service GAS-IRRIGATION/WATER PUMPING
Gas Service GAS-RESIDENTIAL
JGC ACCOUNTS RECEIVABLE-GAS UTILITY Total
GL Account: IGC ACCOUNTS RECEIVABLE-MISAPPLIED UNIVERSAL PAYMENT
Service Type Agreement Type
Gas Service PAYMENTS IN SUSPENSE
IGC ACCOUNTS RECEIVABLE-MISAPPLIED UNIVERSAL PAYMENT Total
GL Account: IGC CUSTOMER DEPOSITS
Service Type
D.eposit Install Bill
Deposit Install Bill
Deposit Install Bill
Agreement Type
CUSTOMER DEPOSIT -COMMERCIAL
CUSTOMER DEPOSIT -LARGE VOLUME
CUSTOMER DEPOSIT -RESIDENTIAL
IGC CUSTOMER DEPOSITS Total
Page 1 of 103
Print Date: 09/01/2015 at 4:10 am
Data Date: 09/01/2015 at 4:04 am
Current Balance
368,922.50
15,533.08
83,186.84
467,642.42
Current Balance
1,731.29
(57.38)
529.85
10.24
0.00
263.35
1,102,484.99
2,594.40
868,023.80
1,975,580.54
Current Balance
(15,374.35)
(15,374.35)
Current Balance
6,825.69
(8,430.00)
62,750.01
61,145.70
Total Balance
368,922.50
15,533.08
83,186.84
467,642.42
Total Balance
7,500.02
(57.38)
529.85
10.24 I
0.00
263.35
898,969.76
2,594.40
(4,766,246/26)
(3,856,436.02)
Total Balance
(168,196.28)
(9,602.00)
(523, 1'46.03)
(700,944.31)
Report: Cl1759
Unclaimed Customer Watch Balances
$ 214.33
2004-2008 $ 185.57
2008-200~· $ 106.99
2009-2010 $ 523.30
2012-2013 $ 385.80
2013-2014 $ 790.36
-2014-2015-$ 1,709.57
2010-2011 $ 612.39
2011-2012 $ 248.10
Total <! 4,776.41)
I> Roles
-Su!JmiiJQQ
-View Job Status
0 Minimize menu on app launch
fjnd qose form
~ X ~
Select a Query
;Account
! LedgerType 1
i Type/Subledger
0Posted
1~1 Do D L. Ty
D JE
D
D
D
D
(
Address
!lumber
aow Reuort Iools
III D lilt
~-----------------------"_,Save Query Edit Queries
48.1432.0910 IAA ~-~--
OUnposted
Balances
Doc LT 1
!lumber Debit
12735
LT1
Credit
@)All
Explanation
-Remark-
13,492.05-IGC FEED
13,492.05-
13,492.05-
13,492.05-
CIS To AIR Clearing Account
General Ledger From Date
Thru Date
YTD 10,597.94-Cumulative
Explanation
IGCTRAN
Column Total
ledger Total
Posted Total
Unpasted Total
j Arians
GIL Batch
Date Date
08/01/2015 09102120 ...
10,597.94-
v[
Batch
Number Units
1322034
>
Select a Query
Account
Ledger Type 1
Type/Subledger
0Posted
Records 1 -1Jl
r-, Do D .~ Ty
D JE
D RC
D RC
D RC
D RC
D RC
D
D
D
D
(
form Jools
tll ~
Ounposted
Address Doc LT1
Number Number Debit
·1273f!
713064 12554 1,317.16
619361 12555 701.60
841528 12556 227.20
742621 12606 162.00
852044 12607 486.15
2,894.11
2,894.11
\ C/S To Al~ Clearing Account
' General Ledger
YTD
LT 1 Explanation
Credit -Remark-
13,492.05-IGC FEED
Misapplied CCB payment
Misapplied CCB payment
Misapplied CCB payment
13,492.05-
10,597.94-
13,492.()5-
Explanation
IGCTRAN
Bank Deposit
Bank Deposit
Bank Deposit
Bank Deposit
Bank Deposit
Column Totaf
ledger Total
Posted Total
From Date
Thru Date
ro8/0112015 -------
10,597.94-Cumulative
I Arlens vi
GIL Batch Batch
Date Date Number Units
08/0112015 09/02120 ... 1322034
0812412015 08124120 ... 1318739
08/24/2015 08/24/20 ... 1318739
08/24/2015 08/24/20 ... 1318739
08/28/2015 08/28/20 ... 1320542
08/28/2015 08/28/20 ... 1320542
Unposted Total
@IQ
>
Schmidt, Arlen
From:
Sent
To:
Cc:
Subject:
Ted,
Gyllenskog, Nicole
... Thursday, December 17, 2015 11:06 AM
Dedden, Ted
· Schmidt, Arlen; Ogami, Niki
Proposed AR Adjustment
We've been reconciling our AR accounts per JOE to the receivable CC&B reports over the last four months since go­
live. We have identified an out-of-balance that has been consistent each month. The difference is between
1420.13101, our cyclical receivable, and CC&B. The difference each month was -$64,860.60 and we were able to
identify $4,776.41 of that balance. Our proposed entry is for $$60,084.19 and is as follows:
Cyclical AR 1420.13101 60,084.19
Misc. Revenue 4880.4880 60,084.19
The reconcifiation below show our outage month over month. Please let me know if you approve the proposed
adjustment and if you have any questions.
1~.J 1
-162
163
164
165
166
167
168.
169
170
1.71
172
173
174
175
176
177
17B
179
1BO
181
182:
183
184
·ms
186
187.
I
!Reconcile SA Balances in CCB to Jde
148.1420.13101
lci1759 SA Balances Gas Utility
iCA1759 SA Balances Pmts in Suspense
lc11744B GL in Fo1Ward Periods 131U1
J-de Balance 13101
Sub total
Cl1759 SA Balances Pmts in Suspense See above Ts accfs
Net difference
1
~~nf?11~~ ·
lci1759 SA Balances Gas Utility
ICl1744B Gl in Fo!V'lard Perios 13101
Sub total
\Jde balance 13101 I Net Dilfarenc<!
1
Cl1509 current month:
Cl1790A Cur mo: CCB mis apply
Reports & Jde Feed bal:
Previous month ending bal:
Jde current true balance:
Jde current end of mo Bal:
CIS to AIR Clearing Account
IRecon 48.1432.0910
-13,492.05
-2,894.11
-10,597.94
0.00
-10,597.94
-10,597.94
·o.oo i
Note: Cl1790A is check to Jde monthly control master
current month.
Jde current true balance: -10,597.94
Cl1759 -15,374.35
Cl1509 current month: -13,492.05
Difference: -1,882.30
Cl1790A Cur mo: CCB mis apply -2,894.11
Cl1790A + Cl1759 -4,776.41
Nicole audit is off
1101{11
JOE Gl@ 8/31 Adjus,ed Cl1759 CI0893 Cl1744B Adjusted Report Difference between JOE and CC&B
1420.13101 $ (4,781,228.10) $ (3,856,436.02) $ (3,856,436.02) 859,931.48 (4,716,367.50) $ {64,860.60) OK
1420.13102 $ 224,631.49 $ 467,642.42 $ 467,642.42 243,010.93 224,631.49 $ OK
1432.0910 $ (10,597.94) $ (15,374.35) $ (15,374.35) (15,374.35) $ 4,776.41 OK CW Unclaimed custom,
$ (4,567,194.55) $ (3,404,167.95) $ (3,404,167.95) $ 1,102,942.41 (4,507,110.36)
Cl1759
Arlen's Misapplied Ui paymt Difference
lseptember 2015 I JOE Gl Adj to Jde Adjusted Jde Amt CI0893 Cl1759 Cl1744B !Adjusted Report between JOE and CC&B
1420.13101 $ (6,084,198.36) -6,084,198.36 -5,335,341.18 -29,922.19 784,998.45 -6,150,261.82 66,063.46 Off 1,202.86
1420.13102 $ 137,754.58 137,754.58 481,773.34 344,018.76 137,754.58 0.00 OK
1432.0910 $ (25,145.78) -25,145.78 -29,922.19 0.00 -29,922.19 4,776.41 OK
Misapplied Ui paymt Difference
loctober 2015 JOE Gl Adj to Jde Adjusted Jde Amt CI0893 Cl1759 Cl1744B !Adjusted Report between JDE and CC&B
1420.13101 -7,483,293.92 71,079.68 -7,412,214.24 -5,718,457.09 -26,263.52 -1,726,239.75 -7,470,960.36 58,746.12 Off -6,114.48
1420.13102 306,330.28 306,330.28 689,197.67 382,867.39 306,330.28 0.00 OK
1432.0910 -21,926.03 -21,926.03 -26,263.52 -26,263.52 4,337,49 Off -438.92
Misapplied Ui paymt Difference I November 2015 JOE Gl Adj to Jde Adjusted Jde Amt CI0893 Cl1759 Cl1744B !Adjusted Report between JDE and CC&B
1420.13101 -4,780,571.19 -550,000.00 -4,230,571.19 -1,729,534.27 -52,038.19 -2,488,214.51 -4,165,710.59 -64,860.60 OK
1420.13102 -1,451,604.64 1,160,089.88 -291,514.76 800,251.18 0.00 -508,736.42 -291,514.76 0.00
1432.0910 -47,700.70 0.00 -47,700.70 -52,038.19 -52,038.19 4,337.49 Off
"OK"
JDE GL @ 8/'iJl AdjusteJ (11759 CI0893 Cl1744B Adjusted Report Difference between JDE and CC&B
1420.13101 $ (4,781,228.,10) · $ (3,856,436.02) $ (3,856,436.02) 859,931.48 (4,716,367.50) $ (64,860.60) OK
1420.13102 $ 224,631.49 $ 467,642.42 $ 467,642.42 243,010.93 224,631.49 $ OK
1432.0910 $ (10,597.94) $ (15,374.35) $ (15,374.35) (15,374.35) $ 4,776.41 OK CW Unclaimed custom,
$ (4,567,194.55) $ (3,404,167.95) $ (3,404,167.95) $ 1,102,942.41 (4,507,110.36)
(11759
Arlen's Misapplied Ui paymt Difference
lseptember 2015 I JDEGL Adj to Jde Adjusted Jde Amt CI0893 (11759 (117448 !Adjusted Report between JOE and CC&B
1420.13101 $ (6,084,198.36) -6,084,198.36 -5,335,341.18 -29,922.19 784,998.45 -6,150,261.82 66,063.46 Off 1,202.86
1420.13102 $ 137,754.58 137,754.58 481,773.34 344,018.76 137,754.58 0.00 OK
1432.0910 $ (25,145.78) -25,145.78 -29,922.19 0.00 -29,922.19 4,776.41 OK
Misapplied Ui paymt Difference
loctober 2015 JDE GL Adj to Jde Adjusted Jde Amt (10893 (11759 (117448 jAdjusted Report between JDE and CC&B
1420.13101 -7,483,293.92 71,079.68 -7,412,214.24 -5,718,457.09 -26,263.52 -1,726,239.75 -7,470,960.36 58,746.12 Off -6,114.48
1420.13102 306,330.28 306,330.28 689,197.67 382,867.39 306,330.28 0.00 OK
1432.0910 -21,926.03 -21,926.03 -26,263.52 -26,263.52 4,337.49 Off -438.92
Misapplied Ui paymt Difference
!November 2015 JDE GL Adj to Jde Adjusted Jde Amt CI0893 (11759 (117448 !Adjusted Report between JDE and CC&B
1420.13101 -4,780,571.19 -550,000.00 -4,230,571.19 -1,729,534.27 -52,038.19 -2,488,214.51 -4, 165,710.59 -64,860.60 OK
1420.13102 -1,451,604.64 1,160,089.88 -291,514.76 800,251.18 0.00 -508,736.42 -291,514.76 0.00
1432.0910 -47,700.70 0.00 -47,700.70 -52,038.19 -52,038.19 4,337.49 Off
Schmidt, Arlen
from:
Sent:
To:
Ce
Subject::-
Gyllenskog, Nicole
_ Tl.lesday, December 29, 2015 1:06 PM
Schmidt, Arlen
Fisette, Melinda
FW: Proposed AR Adjustment
Got one this morning, however, I want to post it separately, I'll help you with the support.
Thanks
from: Dedden, Ted
Sent: Tuesday, December 29, 2015 11:23 AM
To: Gyllenskog, Nicole
Subject: RE: Proposed AR Adjustment
Since you have documentation that the $65.5 difference per the screenshot relates to the pre-Customer Watch legacy
CIS that was written off as Uncollectible Accounts Expense I agree that this adjustment should go to the Allowance for
Doubtful Accounts (reverse the legacy CIS write-off). Since this causes a flip ofthe overall outage amount to $5.4K and
that the difference has been consistent since the CC&B conversion please charge 48514.5630.29030.
Thanks.
Ted Dedden
Director, Accounting & Finance
lntermountain Gas Company
a' Tel: [phone]
J Cell: [phone]
~ Fax: [phone]
181 Email: [e-mail]
from: Gyllenskog, Nicole
Sent: Tuesday, December 22, 2015 11:46 AM
To: Dedden, Ted
Subject: RE: Proposed AR Adjustment
Ted,
After speaking with Cheryl, new information has come to light, thus the Credit account below will change. The screen
shot below is a balance of one of the "dummy," accounts in CW that housed payments that were received for
customer's accounts that were not converted from the legacy system into CW. {Side note; we'll have the same thing in
CC&B but we have a plan to deal with them). As such, I believe the credit should be to our recoveries account
1442.300. Speaking with Cheryl, Arlen and Melinda, the only two "dummy," accounts that were in CW was this account
and the unidentifiable payment account of $4,776.41 that we were already aware of. Marcella also confirmed that the
"dummy," account below was not brought into CC&B.
I realize the balance isn't exactly what we're planning to journal, but I'm suggesting we make the following entry:
Cyclical AR 1420.13101 65,455.58 (Based on CW report below) ,~
Allowance for Doubtful Accounts 1442.300 65,455.58
1
Misc. Expense 5,371.39
Cyclical AR 1420.13101 5,371.6-ef' 11
As far as misc expense accounts, I'm not sure what we want to use here. If we can assume that it's customer account
related I thought 29050, however, we have never used that account. It looks like we put everything in 29030. I'm up
for suggestions here please!
E;i;~~'l>·=..one
J!.or ~'{c.n. .... P-&7
7·s<tO l!: s :»· ·03co ni,.1.i, n,
rf ~s,. ..;.ss ~ .s.&}
\$->$$,.'4!f;:~~.S.S}
l'Q.00
fc(L M
$0.:00
$0.00
io.oo
fil.¢,. .fu.1<k
V
:no~-e
;r,r
:~::as,: S':1.l..I.. oo,.IZ'~i:
:,?ta.$te S"il.l. D..-:-c•
\I,.,,l.u,qs...nt Pat-, r?~t bl.J.t?-:~curt.,; -
·,Di1..,¢0l'l.!:"!ll!<C:!: O.~-'d,el!' D~111:1:
lt.:t:livitcy ·~--d
~~c::n: ~-c-o ;,q ~ra.tt, p:ay
tE.o-~ D.r:-11 !i:. h.o\b1C.
~1'ru.e .eu~-cc
}_~-c:at:~~-c.~~ ~r~;!:
i~?_n.1!'~~~~1i!~~n,~~d Ch~r·g~~
.{L~At:1 1}~~~ ... Sa!Ar.1,:~
?·te-r,,-.trl. PAy ~A!..l.:t.Jtl:ie-S j
ll>.....,;s::,.,:.;-. :fwU.
~J::tth~r S-::cu.r.1.ty
y ,3.Y=t~;;.'t,. r; .. -3°?;.'I!
t.ast· Jla"Yl(t"!:r.fC .b012i.t
i~f-~==-~ Hant.!!.1~g
a,
·:i.0.1.-io
0'3/.l7/0f.t
·cy:.Jl. 7/0@
10.0:0
1'6p .. r
l1ct ca, Aue<> X>nd:-
(t:_06'S,..4.SS-.:5$:)
.f:O~O~
:$0.01:ll
::-D~O:ti
07/Z~/'.lS:
$1-8. 2:2
·*
,• • •• '••••• •• • •• ••• ·. «. • ,,,,,,__ .-,v=~«~~•-m.~,, ,,,=•., .. =.,«-•~N•--;;:_,, ~ ... N~:. •~-•_««,,«'.~-------• ,,,_~~" .~m~ _ ------:,,-___ ,N~~-~-"S-=«-
The GL associated with this account:
/~
2
r;;;
harge Detail List
ccouni:. Code -V Account DescrifJt.ion Customer.flame
Ol2000020000l:Cyclical Accounts Receivab::Purge Account, Ufriteo ff
200l3lOl2000020000lCyclical Accounts ReceiTa•ab:'Purge Account, Ufriteo ff
From: Dedden, Ted
Sent: Tuesday, December 22, 2015 10:50 AM
To: Gyllenskog, Nicole
Subject: FW: Proposed AR Adjustment
($l2-52)
($l2_ 52)
See Mark's approval to write off the initially proposed $60K adjustment which has been reduced to approximately $(SK)
per this morning's discussion.
Thanks.
Ted Dedden
Director, Accounting & Finance
lntermountain Gas Company
0 Tel: [phone]
J Cell: [phone]
iQi Fax: [phone]
l8J Email: [e-mail]
From: Chiles, Mark
Sent: Thursday, December 17, 2015 11:53 AM
To: Dedden, Ted
Subject: RE: Proposed AR Adjustment
I'm okay with the adjustment.
~
i!J;;;;J!,.4...,m,ff'/dJ£:7.f,~!"~ O~ Pl<: inti,,, ~-1.1::, u,~
Mark A. Chiles
Vice President and Controller -Western Region
lntermountain Gas Company and Cascade Natural Gas Corporation
Subsidiaries of MDU Resources Group, Inc.
555 South Cole Road
P.O. Box 7608
Boise, ID 83707
Phone No. -[phone]
Fax No. -[phone]
E-Mail [e-mail]
From: Dedden, Ted
Sent: Thursday, December 17, 2015 11:31 AM
To: Chiles, Mark
Subject: FW: Proposed AR Adjustment
Mark,
3
Nicole, Arlen, Melinda, and Niki have been working on an out of balance condition between CC&B and JOE since go­
live. The total is $6SK however they're confident that they can identify $SK of that difference with further research.
support their request to resolve the remaining $60K unidentified difference by crediting Misc. Revenue. This would
bring JOE and CC&B in balance pending resolution of the remaining $SK.
Pfease fet me know if you any concerns or questions.
Thanks.
Ted Dedden
Director, Accounting & Finance
lntermountain Gas Company
S Tel: [phone]
J Cell: (208) 724-S677
~ Fax: [phone]
[8l Email: [e-mail]
From: Gyllenskog, Nicole
Sent: Thursday, December 17, 2015 11:06 AM
To: Dedden, Ted
Cc: Schmidt, Arlen; Ogami, Niki
Subject: Proposed AR Adjustment
Ted,
We've been reconciling our AR accounts per JOE to the receivable CC&B reports over the last four months since go­
live. We have identified an out-of-balance that has been consistent each month. The difference is between
1420.13101, our cyclical receivable, and CC&B. The difference each month was -$64,860.60 and we were able to
identify $4J76.41 of that balance. Our proposed entry is for $$60,084.19 and is as follows:
Cyclical AR 1420.13101 60,084.19
Misc. Revenue 4880.4880 60,084.19
The reconciliation below show our outage month over month. Please let me know if you approve the proposed
adjustment and if you have any questions.
4
t-•J1
162
463
164
16:S
166
467
168
169
470
474
172
173
174
175
176
1T!
178
179
480
181
1B2
183 -134
185
186
187
Thanks,
Nicole Gyllenskog
Manager, Accounting Systems
I
1
1
Reconcile SA Balances in CCB to Jde
48.1420.13101
lci1759 SA Balances Gas Utility
ICAH59 SA Balances Pmts in Suspense
1Cl1744B GL-in Forward Periods 13101
Jde Balance 13101
Sub total
ICl1759 SA Balances Pmts in Suspense
t·Jet difference
li~ociii::ition
Ci1759 SA Balances Gas Utmty
Ci1744B GL in Forward Perios 13101
Sub total
Jrle balance 13101 I Net Difference
5
See above rs accfs