search

bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 57 forks source link

FAS GL coding - update for FIN #21264

Open pstemkens opened 1 month ago

pstemkens commented 1 month ago

FAS uses CAS's Receipt Method called BC REG Cash Equivalent. This is the GL coding for this Receipt Method:

Cash Account 112.32363.34725.4375.3200009.000000.0000 Bank Charges 112.32374.34725.8506.3200009.000000.0000 Unapplied Receipts 112.32363.34725.1278.3200009.000000.0000 Unidentified Receipts 112.32363.34725.1278.3200009.000000.0000 On Account Receipts 112.32363.34725.1278.3200009.000000.0000

FIN reported refunds are paid out of GL Coding 112.32363.34725.4376.3200000. ( this STOB is for BCROS) We confirmed refunds are currently coming out of 112.32562.20245.1474.32000. FIN confirmed that ( this STOB is for BCOL) 20245 is incorrect. We need to investigate further.

pstemkens commented 1 month ago

Review coding with FIN at next meeting

pstemkens commented 1 month ago

FIN confirmed that 112.32562.20245.1474.32000 is for BCOL, ( 20245) is incorrect. We need to investigate further.

JohnamLane commented 1 month ago

Next steps @seeker25 @pstemkens @avni-work Can we please create a sequence diagram for the above flow in FAS? This would need to include the flow from:

  1. Receiving money (entering RS)
  2. RS being spent on a service + revenue disbursement
  3. Steps that occur when a paid service is refunded (undo disbursement?)
seeker25 commented 1 month ago

Hello John,

Sounds good - We can get a diagram going, I'll cut a ticket

pstemkens commented 4 weeks ago

@JohnamLane email from Karen @ FIN from Feb 2023 provided us with the GL we are using for refunds.

From: Berben, Karen CITZ:EX [Karen.Berben@gov.bc.ca](mailto:Karen.Berben@gov.bc.ca) Sent: Thursday, February 2, 2023 9:43 AM To: Semple, Travis CITZ:EX [Travis.Semple@gov.bc.ca](mailto:Travis.Semple@gov.bc.ca); Whalen, Tara FIN:EX [Tara.Whalen@gov.bc.ca](mailto:Tara.Whalen@gov.bc.ca); Nichols, Lisa A CITZ:EX [Lisa.Nichols@gov.bc.ca](mailto:Lisa.Nichols@gov.bc.ca) Cc: Lane, John AM CITZ:EX [John.A.M.Lane@gov.bc.ca](mailto:John.A.M.Lane@gov.bc.ca) Subject: RE: AP refunds

Good morning Travis,

Supplier Number 999987 Site 001 Client 112 Resp 32562 Service Line 20245 Stob 1474

Karen Berben Cash Management Officer Strategic Services Branch – Service BC Division – Ministry of Citizens’ Services, E 161 - 4000 Seymour Place, Victoria BC, V8X 4S8 Email: Karen.Berben@gov.bc.ca; Phone: 250-419-8734

pstemkens commented 3 weeks ago

From FIN: Here is a list of GL coding for PAD and credit cards:

PAD: 112.32363.34725.4375.3212308 Amex: 112.32363.34725.4375.3212309 VISA: 112.32363.34725.4375.3212313 MC: 112.32363.34725.4375.3212314 VISADebit: 112.32363.34725.4375.3212315 MastcardDebit: 112.32363.34725.4375.3212317

@JohnamLane We need to confirm with CAS.

pstemkens commented 1 week ago

@JohnamLane , we met with Tara and she provided us with examples.

pstemkens commented 2 days ago

@seeker25 , still waiting for Tara to provide us with the additional scenarios.