P RODUCING CARCTGL # 2017ACA CAP C OPYING CARCTGL # 2017ACA CAP P - - PowerPoint PPT Presentation

▶
p roducing carctgl
SMART_READER_LITE
LIVE PREVIEW

P RODUCING CARCTGL # 2017ACA CAP C OPYING CARCTGL # 2017ACA CAP P - - PowerPoint PPT Presentation

Nov 26, 2022 253 likes •405 views

E XCELING WITH YOUR CARCTGL Michial Armstrong Teresa Shaw PHOTOGRAPH CREDIT MICHAEL HIBBLEN KUAR NEWS Building Bridges # 2017ACA CAP Ar Arkansas kansas Cour Court t Automa utomation tion Pr Prog ogram am Syst Systems ems Conf

slide-1
SLIDE 1

EXCELING WITH YOUR

CARCTGL

Ar Arkansas kansas Cour Court t Automa utomation tion Pr Prog

  • gram

am Syst Systems ems Conf Confer erence ence 2017 2017

Building Bridges

Michial Armstrong Teresa Shaw

#2017ACA

CAP

PHOTOGRAPH CREDIT MICHAEL HIBBLEN KUAR NEWS

slide-2
SLIDE 2

USING CONTEXTE DATA

WITH EXCEL

#2017ACA

CAP

  • CARCTGL (Contexte General Ledger) data may be exported to

Excel for troubleshooting/disbursement purposes.

  • Excel allows for a compilation of accounting data to detect

errors.

  • An Excel spreadsheet template is available for your use –

contact acap.help@arcourts.gov.

slide-3
SLIDE 3

WHAT YOU NEED TO

GET STARTED

#2017ACA

CAP

  • Contexte CARCTGL Report
  • Contexte CARCKST Report for outstanding checks
  • Contexte CZRRCPT Report for receipt listing
  • Microsoft Excel
  • Excel file template for CARCTGL data
  • Bank Statement
slide-4
SLIDE 4

PRODUCING CARCTGL

#2017ACA

CAP

slide-5
SLIDE 5

COPYING CARCTGL

#2017ACA

CAP

slide-6
SLIDE 6

PASTING & FORMATTING CARCTGL INTO EXCEL

#2017ACA

CAP

slide-7
SLIDE 7

WORKING WITH EXCEL

FORMULAS

#2017ACA

CAP

slide-8
SLIDE 8

UNDERSTANDING

DISBURSEMENT FROM CARCTGL

#2017ACA

CAP

slide-9
SLIDE 9

IDENTIFYING OVER/SHORT

#2017ACA

CAP

slide-10
SLIDE 10

OVER/SHORT EXPLAINED

#2017ACA

CAP

  • Over/Short Negative (-) Amount:
  • Contexte has more receipts than deposited in the bank
  • Possible Reasons:
  • Receipt posted in Contexte but not sent in a deposit to the

bank.

  • INA deposit error where receipt is created in Contexte but no

corresponding deposit in the bank.

  • Disbursement error from previous posting period.
slide-11
SLIDE 11

OVER/SHORT EXPLAINED

#2017ACA

CAP

  • Over/Short Positive (+) Amount:
  • The bank has more in deposits than Contexte receipts
  • Possible Reasons:
  • Deposit or bank transfer made in the bank account with no

corresponding receipts in Contexte.

  • INA deposit error where a deposit occurs to the bank account

but no receipt is created in Contexte.

  • Disbursement error from previous posting period.
slide-12
SLIDE 12

DEPOSIT RECONCILIATION

#2017ACA

CAP

slide-13
SLIDE 13

DEPOSIT RECONCILIATION

#2017ACA

CAP

slide-14
SLIDE 14

CONCLUSION

Thank you for attending! Michial Armstrong Michial.Armstrong@arcourts.gov Teresa Shaw Teresa.Shaw@arcourts.gov

#2017ACA

CAP