slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
FINANCIAL SERVICES CENTER TRAINING FACILITY AUSTIN, TX PRESENTS PowerPoint Presentation
Download Presentation
FINANCIAL SERVICES CENTER TRAINING FACILITY AUSTIN, TX PRESENTS

Loading in 2 Seconds...

play fullscreen
1 / 179

FINANCIAL SERVICES CENTER TRAINING FACILITY AUSTIN, TX PRESENTS - PowerPoint PPT Presentation


  • 170 Views
  • Uploaded on

FINANCIAL SERVICES CENTER TRAINING FACILITY AUSTIN, TX PRESENTS. F M S II II. FSC Training Staff (512) 460-5059. A/O Apr 2010. The FLITE Future Financial and Logistics Integrated Technology Enterprise Program. 3 Primary Components of FLITE: SAM – Strategic Asset Management System

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'FINANCIAL SERVICES CENTER TRAINING FACILITY AUSTIN, TX PRESENTS' - arama


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

FINANCIAL SERVICES CENTER TRAINING FACILITYAUSTIN, TXPRESENTS

F M S II II

FSC Training Staff

(512) 460-5059

A/O Apr 2010

the flite future financial and logistics integrated technology enterprise program
The FLITE FutureFinancial and Logistics IntegratedTechnology Enterprise Program
  • 3 Primary Components of FLITE:
    • SAM – Strategic Asset Management System
      • Replaces: AEMS/MERS, IFCAP, GIP, PIP, CAI, MMS
      • National Deployment: 4Qtr 2011 – 2Qtr 2013
    • IFAS – Integrated Financial Accounting System
      • Replaces: FMS, IFCAP
      • National Deployment:
        • FMS Replacement: 1Qtr 2011 – 4Qtr 2011
        • IFCAP Replacement: 3Qtr 2012 – 1Qtr 2014
    • Data Warehouse
  • Website: http://vaww.va.gov/flite/
slide3

TABLE OF CONTENTS

Section 1 1-1 thru 1-2

Introduction/Outline

Section 2 2-1 thru 2-25

FMS Research Techniques

MSGL

GLTS

GLDB

Section 3 3-1 thru 3-24

Accounts Receivables

Negative PV 03

Treasury Offset Program (TOP) System

Section 3a

Payments

Zero PV 01

Section 4 4-1 thru 4-28

Payroll Transactions

Section 5 5-1 thru 5-39

Travel Transactions

Section 6 6-1 thru 6-6

Financial Indicator Report

Section 7 7-1 thru 7-8

F911 vs Macro

Section 8 8-1 thru 8-10

Annual close Memo

Section 9 9-1 thru 9-6

Annual Close/Trial Balance

Section 10 10-1 thru 10-6

Journal Voucher

slide4

Section 1

Introduction

slide5

Introduction

  • Class Schedule:Class start: 8:30 a.m.
  • Class ends: 4:00 p.m.
  • Objective: At completion of this course the student will be able to:
          • FMS Research Techniques
          • MSGL
          • GLTS
          • GLDB
          • Accounts Receivables
          • Billing Documents (BD)
          • Negative PV 03
          • Treasury Offset Program System (TOP)
          • Payroll Transactions
          • Expenditures (PR )
          • Billing Documents (BD)
          • Unfunded Expense (UE)
          • TDY Travel
          • F854 Report Out of Balances for Employee Advances
          • Common Problems
          • Solutions

1-1

slide6

Introduction

  • Objective: At completion of this course the student will be able to:
          • Financial Indicators
          • Web Site
          • 889B report
          • 3875
          • F911 report vs Macro
          • Common Issues
          • Annual Close Memo
          • Annual Close and Trial Balance
          • Journal Vouchers
          • Station’s Journal voucher
          • FSC Journal voucher

1-2

slide7

WEBSITES

http://vaww4.va.gov/FINANCE/policy/index.asp-VA Directives, Handbooks, Bulletins

http://www.fsc.va.gov/ - FSC homepage/Training

http://vaww1.va.gov/fmshome/ - FMS Users Guide and Monthly Reports

http://vaww.fscdirect.fsc.va.gov - FMS GL and Proforma

http://vaww.fscdirect.fsc.va.gov/newsflash - NewsFlashes

http://austin.aac.va.gov - RSD reports and FMS Internet Access

http://vaww.frs.aac.va.gov/access.asp – FRS - Financial Reporting System

https://vaww.aac.va.gov/ssw – FMS SnapShot Web - Access

https://vaww.snapwebfms.aac.va.gov – FMS SnapShot Web - Archived Reports

http://vaww.cfo.med.va.gov/173/alerts_toc.asp - Alerts

http://reports.vssc.med.va.gov/ReportServer/Pages/ReportViewer.aspx?%2fFINANCE%2fFY10+Financial+Indicators+Report&rs:Command=Render - Financial Indicators

1-3

slide8

Section 2

FMS Research Techniques

example of boct fy differences
Example of BOCT FY Differences

It is important to look up the BOC by fiscal year of the transaction. For example: You are trying to process an EW from Fund 0160A1, FY 10, BOC 1150 for performance awards to Fund 0160X4, BFY 94.

If you look on the BOCT table for FY 94 BOC 1150 did not exist. In scanning the BOCT table for FY 94 you will find that BOC 1114 is for performance awards.

ACTION: R TABLEID: BOCT USERID: S104 AFA

BUDGET OBJECT CODE REFERENCE DATA SCREEN

KEY IS BUDGET FISCAL YEAR, BUDGET OBJECT CODE

FED BOC SUB BOC OBL= REST

BOC OBJ OBJ PS BOC 1099 TRAVEL BUDG POST EXP LKUP DEACT

FY CODE CLS CLS IND IND IND FLAG FLAG LMT FLAG BOC FLAG DATE

-- ---- --- --- --- --- ---- ------ ---- ---- ---- ---- ---- --------

01- 10 1150 110 11 Y Y N N N 11 N Y N

NAME: PERFORMANCE AWARDS SHORT: PERFMNC AWDS

02- 10 1151 110 11 Y Y N N N 11 N Y N

NAME: EXECUTIVE NURSES SPECIAL PAY SHORT: NURS SPCL PY

ACTION: R TABLEID: BOCT USERID: S104 AFA

BUDGET OBJECT CODE REFERENCE DATA SCREEN

KEY IS BUDGET FISCAL YEAR, BUDGET OBJECT CODE

FED BOC SUB BOC OBL= REST

BOC OBJ OBJ PS BOC 1099 TRAVEL BUDG POST EXP LKUP DEACT

FY CODE CLS CLS IND IND IND FLAG FLAG LMT FLAG BOC FLAG DATE

-- ---- --- --- --- --- ---- ------ ---- ---- ---- ---- ---- --------

01- 94 1111 110 11 Y Y C N N 11 N Y N

NAME: SPECIAL PAY F/T DENTISTS SHORT: F/T DEN S/P

02- 94 1112 110 11 Y Y C N N 11 N Y N

NAME: SPECIAL PAY P/T PHYSICIANS SHORT: P/T PHYS S/P

03- 94 1113 110 11 Y Y C N N 11 N Y N

NAME: SPECIAL PAY F/T PHYSICIANS SHORT: F/T PHYS S/P

04- 941114 110 11 Y Y C N N 11 N Y N

NAME: PERFORMANCE AWARDS SHORT: PERF.AWARDS

05- 94 1115 110 11 Y Y C N N 11 N Y N

NAME: SENIOR EXEC.SERVICE BONUS SHORT: SES BONUS

06- 94 1116 110 11 Y Y C N N 11 N Y N

NAME: REEMPLOYED ANNUITANTS REIMB SHORT: REEMP. ANNUI

2-6

example of reject aced acen acev boct
Example of RejectACED/ACEN/ACEV/BOCT

COMMND:                 DOCID: ET 40   832Z50005              STATUS: HELD      001-001 OF 002          BATID:                   SUB STN:          03/23/09     01-                                                                                    LINE: 001 REF DOC: CO 832Z50005       REF LINE: 001 ACCP DATE:               PAY ADV:     REF ADV:                REF ADV LINE:      INV DATE:                 VENDOR INV NO/LINE:                                   LOG DATE:                   T/T: 01     BFYS: 07           FUND: 0111                                    STATION/SAT: 832               FCP/PRJ: EF3021           JOB NO: 14            COST CTR/SUB:                   BOC/SUB: 2549          REPT CATG:               REV SRCE/SUB:                 CLSD BFYS:               CLSD FUND:                 GL ACCOUNT:                     DESCR: SEE LINE 002-CORRECT FUND APPN          LINE AMOUNT: 350000.00             I/D: D  P/F:      INT REASON:                 LIQ AMOUNT:                  QUANTITY:                     ADV:               UNAPPLIED DEP NO:                 01-CPM02-TRAN CODE/TYPE NOT IN ACED 

ACTION: R TABLEID: BOCT USERID: S104 FSC

BUDGET OBJECT CODE REFERENCE DATA SCREEN

KEY IS BUDGET FISCAL YEAR, BUDGET OBJECT CODE

FED BOC SUB BOC OBL= REST

BOC OBJ OBJ PS BOC 1099 TRAVEL BUDG POST EXP LKUP DEACT

FY CODE CLS CLS IND IND IND FLAG FLAG LMT FLAG BOC FLAG DATE

-- ---- --- --- --- --- ---- ------ ---- ---- ---- ---- ---- --------

01- 07 2549 250 25 N N C N N 25 Y Y N

NAME: ROADS AND GROUNDS MAINTENANCE SHORT: RDS&GRNDS MN

2-7

slide21

The FMS Accounting Codes

  • Accounting Codes are used to indicate the accounting distribution associated with each document. When entering the accounting codes, enter only those which are relevant to the budget affected by the document.
  • Fund codes (FUND) represent various combinations of an appropriation code, category, and limitation. The new budget structure uses the FMS "Fund Code" to identify the limitation code in addition to the appropriation and apportionment codes, (e.g. 0160A1).
  • An Administration/Staff Office (A/O) code stands for the Administration or Staff Office that manages a given fund. A/O codes are also used to identify the user entering a document.
  • A/O
  • 04 – FSC/VACO Finance
  • 10 – Medical Centers
  • 20 – VBA Veterans Benefit Admin
  • 40 – National Cemetery
  • 90 – OAMM/Supply Fund (4537B)
  • 08 – Construction (if CO is funding)
  • 02 – District Counsel
  • Station Numbers (STATION/SAT) are the three-character identifiers assigned to each VA station.
  • Budget Object Codes (BOC/SUB) are four-character fields used to identify goods and services purchased with Federal funds. The first two digits of each BOC (referred to as the object class) are standard within the Federal government.
  • Cost Centers (COST CTR/SUB) are six-character, non-budgetary, organization codes used to record expenditures of funds by various organizations within VA.
  • Fund Control Point (FCP) – also known as Accounting Classification Codes (ACC) – this is comprised of four codes with the following format:
  • CharacterDescription
  • 1-2 Program Code
  • 3-4 Sub-program Code
  • 5-7 Organization Code
  • 8-9 Activity Code

2-13

proforma web site
Proforma Web site
  • http://vaww.fscdirect.fsc.va.gov/
  • Discuss comparable transaction codes and transaction type for transaction code CR.

2-23

slide37

Section 3

Accounts Receivable, Negative PV 03s, Treasury Offset Program (TOP)

slide38

The Accounts Receivable Subsystem is the FMS method for recording and managing outstanding receivables and accurately applying cash receipts. The VA will use this subsystem to record the amounts billed and collected, including revenue transactions for services rendered, vendor refunds, balance sheet transfers, and cash advances. The Accounts Receivable Subsystem allows the VA to account for these billings and collections for financial accounting and reporting purposes. This chapter contains the following information on how to:

    • Process a Billing Document (BD) to record a bill for collection.
    • Process a Cash Receipt (CR) to record a cash collection.
    • Process a Write-off (WR) document to record an accounts receivable write-off.

3-1

negative pv 03
Negative PV 03

COMMND: DOCID: PV 04 FSC9K026701 STATUS: ACCPT

001-001 OF 001 BATID: SUB STN: 10/30/09

PAYMENT VOUCHER INPUT SCREEN

TRANS TYPE: 03 PV DATE: ACCT PRD: ACTION: SUB STN: 104

VENDOR CODE: 752574581 02 NAME: BIG SPRING HOSP CORP

BENEFICIARY: PPAY TYPE: ADDR1: SCENIC MOUNTAIN MED CTR

SCHD PMT DATE: FISCAL APRV: ADDR2: PO BOX 1288

DOC TOTAL: 1294.89 CITY/ST/ZIP: BIG SPRING TX 797211288

CHECK TYPE: COMMENT TO PRINT:

DISC %: DAYS: P/E TERM: AMT:

DISC %: DAYS: P/E TERM: AMT:

01-

LINE: 001 REF DOC: BD FSC0K0267 REF LINE: 001 ACCP/DEL DATE:

VENDOR INV: BOCFSC0K0267OCT1006 INV DATE: 10 14 09 LOG DATE:

REF VEND CODE: REF VEND NAME:

LINE AMOUNT: 1294.89 I/D: D P/F: UNAPPL DEP NO:

LIQ AMOUNT: DESCR:

OUTST OBLIG: 0.00 LINE TYPE: INT RSN: DISC RSN:

BFYS: 10 FUND: 0160A1

STATION/SAT: FSC FCP/PRJ: 0100222V1 JOB NO:

COST CTR/SUB: 822200 00 BOC/SUB: 2560 REPT CATG:

REV SRCE/SUB: CLSD BFYS: CLSD FUND:

A--*HS60-DOCUMENT MARKED FOR READ ONLY

ACTION: R TABLEID: GLDB USERID: S104 FSC

*** GENERAL LEDGER DETAIL BALANCE INQUIRY SCREEN ***

FY BFY FUND GL ACCT AD/OF STN COST CTR FCP/PRJ BOC/REV SRCE TYPE

-- ----- ------ ------- ---- ------- -------- --------- ------------ ----

10 10 0160A1 1321 10 FSC 822200 0100222V1 2560 01

TRANS ID DATE FM REF DOCUMENT VENDOR VENDOR INV # AMT

------------- ------ -- ------------- ----------- -------------------- -----

PVFSC0K026701 081010 01 BDFSC00267 75257458102 BOCFSC0K0267OCT1007

1,294.89

3-9

negative pv 0347
Negative PV 03

ACTION: R TABLEID: ARHT USERID: S104 RMJ

*** RECEIVABLE HEADER INQUIRY SCREEN ***

KEY IS TRANS CODE, DOC NO

TRANS CODE: BD DOC NUM: FSC0K0267 DOC TYPE: SUB STN: 104

DOCUMENT DATE: 10 03 09 COMMENTS:

PAYER CODE/NAME: 75257458102 / BIG SPRING HOSP CORP

ADDR1: SCENIC MOUNTAIN MED CTR

ADDR2: PO BOX 1288

CITY/ST/ZIP: BIG SPRING TX 79721 1288

COLL DUE DATE: LAST BILL DATE/AMT: / 0.00

PRINT BILL: N BILL PRINT DATE: BILLED AMT: 1,294.89

INT RATE: 0.000 INT APPLY DATE: INTEREST AMT: 0.00

TEXT TYPE: ADM CHGS APPLY DATE: ADM CHGS AMT: 0.00

WAIVER FLAG: PEN APPLY DATE: PENALTY AMT: 0.00

DUNNING COUNT: 00 LAST DUN DATE: TOTAL AMT: 1,294.89

OVERDUE STATUS: OVERDUE DATE: COLLECTED AMT: 0.00

WRITE-OFF FLAG: WRITE-OFF DATE: WRITE-OFF AMT: 0.00

WRITE-OFF REASON: DOC CLOSE DATE: 10 10 09 OFFSET AMT: 1,294.89

OFFSET: Y OFFSET APPLIED: 0.00 CLOSED AMT: 1,294.89

OVRPYMT CAUSE: CASE HISTORY FLAG: N REPRINT BILL AMT: 0.00

AGREEMENT NO: OUTSTANDING RECV AMT: 0.00

RGLDATV RSD FORM: F840

10/30/09 PV 03 FSC0K026701 001 10 0160A1 10 0100222V1 2560 N 1321 1,294.89 1313 1,294.89

490N 1,294.89 3107 1,294.89

5700 1,294.89 4610 1,294.89

9946 1,294.89 9945 1,294.89

3-10

negative pv 0348
Negative PV 03

RARVGLV FSC 0160A1

REPORT ID: RARVGLV *** DEPT OF VETERANS AFFAIRS (FMS) *** PAGE: 22

RSD FORM: F853 VERIFICATION OF GENERAL LEDGER BALANCES - ACCOUNTS RECEIVABLE TIME: 22:22

RUN DATE: 10/31/09 FEDERAL/NON-FEDERAL REPORT AS OF 10/30/09

STN: FSC BFYS: 10 FUND: 0160A1 PAYOR TYPE CATEGORY: NON-FEDERAL

WEST TEXAS VA HEALTHCARE SYSTM MEDICAL SERVICES - LMT1 A/O: 10

VETERANS HEALTH ADMIN

REV LAST ACT

DOCUMENT ID LINE FCP/PRJ BOC SRCE REF DOC ID LINE DATE DATE PAYOR CODE NAME OUTSTANDING AMOUNT

BD FSC0K0267 001 0100222V1 2560 12/14/08 10/30/09 752574581 02 BIG SPRING HOSP CORP 1,294.89

NUMBER OF RECORDS: 89 STN 519 SUBTOTAL AMOUNT: 39,279.63

RARVGLV FSC 0160A1

REPORT ID: RARVGLV *** DEPT OF VETERANS AFFAIRS (FMS) *** PAGE: 23

RSD FORM: F853 VERIFICATION OF GENERAL LEDGER BALANCES - ACCOUNTS RECEIVABLE TIME: 22:22

RUN DATE: 10/31/09 FEDERAL/NON-FEDERAL REPORT AS OF 10/31/09

STN: FSC BFYS: 10 FUND: 0160A1 PAYOR TYPE CATEGORY: NON-FEDERAL

WEST TEXAS VA HEALTHCARE SYSTM MEDICAL SERVICES - LMT1

OUTSTANDING AMOUNT

-------------------

ACCOUNTS RECEIVABLE TOTAL: 39,279.63

G/L ACCOUNT BALANCES:

G/L ACCOUNT BALANCES:

G/L G/L

ACCT ACCT NAME BALANCE

---- ------------ -------------------

1311 AR-REIM-OTH 37,806.90

1313 AR-REFD-OTH 177.84

1321 AR-REFD-CR M 1,294.89

G/L TOTAL: 39,279.63

DIFFERENCE: 0.00

3-11

negative pv 0349
Negative PV 03

ACTION: R TABLEID: UPVT USERID: S104 FSC

*** UNPAID VOUCHER INQUIRY SCREEN ***

KEY IS SCHEDULE DATE, DISBURSING OFFICE, VENDOR CODE, TRANS CODE, VOUCHER

NUMBER, TRAVEL ADVANCE NUMBER

SCHEDULE TRANS VOUCHER TRVL ADV

DATE D.O. VENDOR CODE CODE NUMBER NUMBER AMOUNT

-------- ---- ------------ ---- ----------- -------- -----------------

01- 10 30 09 220 752574581 02 PV FSC0K026701 -1,294.89

RSD Form: F826 Status of Allowance

STN: FSC BFYS: 10 Fund: 0160 A/O: 10 Fund Code: 0160A1

WEST TEXAS VA HEALTHCARE SYSTM MEDICAL SERVICES - LMT1 VETERANS HEALTH ADMIN

Program: 28 Total Available

Budget Obligations Amount

Orgn/Act thru MAR 10 thru MAR 10 thru MAR 10

280022166 HALFWAY HOUSE 3,328.00 3,328.00 0.00

Undist to Program: 142,902.00 142,902.00

================== ================== ==================

Program 28 Total: 162,380.00 19,478.00 142,902.00

Suballowance for 0160A1 Total: 14,707,424.71 20,415,086.68 -5,707,661.97

Allowance for 0160A1 Total: 20,463,251.00 20,415,086.68 48,164.32

NOTE: THIS TOTAL DOES NOT DEDUCT A BALANCE OF $1,294.89 IN G/L 1321 AND MUST REMAIN UNOBLIGATED FOR BFY 10, FUNDCODE 0160A1.

3-12

slide52

Here is the information, which will clarify who is responsible for the accounts receivables.http://www.va.gov/publ/direc/finance/M4P8C27.htm

  • . RECORDS, REPORTS, AND ACCOUNTING
  • 27.01 RECORDS
  • a. As managers, all field station Fiscal activities, VACO Finance Service, and the Debt Management Center (DMC) must establish and maintain accounts receivable records in a current status by program, type of debt, and appropriation. All collection actions taken, collections received, amounts offset, waiver action, etc., including adjustments of any kind on a debtor's account, are to be timely documented in the Department's accounts receivable records.
  • b. Complete records are to be maintained, by program, type of debt, and appropriation, of accounts receivable waived, compromised, suspended, terminated or referred to the District Counsel (DC) or Department of Justice (DOJ) for enforced collection so that reports required by paragraph 27.02 and ad hoc reports required by management can be completed.
  • c. All VA components who refer accounts receivable to other VA components or external agencies for additional collection action or advice are responsible for keeping informed of the current status of those receivables (reconciling their accounts with the component the debts were referred to) and for reporting and accounting purposes.
  • Here is some additional information.  This report is generated each pay period.
  • At the time payroll processes a Record Print Out (RPO) is generated for employees on LWOP and whose FEHB is advanced by the agency.  This information goes to FMS and appears on the F842 report in RSD. 

3-15

slide53

CAPPS Write Off Criteria

Note: Amounts greater than $99,999.99 or older than 360 days

will never be written off automatically. Needs to be reviewed

manually then written off if appropriate.

3-16

slide54
REPORT NAME: CAPJ

PAGE 99 REPORT NO. 040 06/16/09 FMS/CAPP RECEIVING REPORT WRITEOFFS VARIABLE TABLE DOLLAR AMOUNT AND AGING CRITERIA AMOUNT LIMIT 499.75 AND DAYS 180 AMOUNT LIMIT 500.00 AND DAYS 241 AMOUNT LIMIT 99,999.99 AND DAYS 360 EASTERN DIVISION STATION PAT DOC TYPE DLN SHIPPING RR AMOUNT ADJ/ENTRY OPR FSC A79002 A 32668111104 .00 .02 CAPSPLIT STATION TOTALS .00 .02 ITEM TOTAL 1 NOTE: There are three types of document types for the receiving report write off: A is for abstracted receivers, stations received more goods than what the vendor is billing for. R-is for open receivers awaiting invoices. W is for receiving reports written off. The document types will be seen in the CAPPS System and this report. When the modifications are done by the stations through FMS, the stations must contact Austin (FOS) to have the CAPPS System updated manually.When the CAPPS system does a write off, you will see a “W” for the document type and a 0.00 CV document will be generated.

3-17

slide55

ACTION: R TABLEID: DXRF USERID: S104 FIH *** DOCUMENT CROSS REFERENCE INQUIRY SCREEN *** KEY IS TRANS ID, F/B POINTER, REF TRANS ID, ACCEPDATE, DOC ACTION TRANS CODE: MO TRANS NUMBER: FSCA99002 DOC TOTAL: 2,198.10 OUTST AMT: 0.00 REF TRANS ID ACCEP DOC F/B/A TC NUMBER DATE ACT VENDOR AMOUNT ----- ----------------- -------- --- ------------ ----------------- 01- A 11 21 08 E 840603850 2,198.12 LAST BATCH NUMBER: CLEARING ACTION: 02- A 01 04 09 S 840603850 -0.02 LAST BATCH NUMBER: ER004 CLEARING ACTION: 03- F RT FSCA9900201 11 22 08 E 840603850 2,198.12 LAST BATCH NUMBER: CLEARING ACTION: 04- F RT FSCA9900201 01 04 09 M 840603850 -0.02 LAST BATCH NUMBER: ER004 CLEARING ACTION: ACTION: R TABLEID: DXRF USERID: S104 FIH *** DOCUMENT CROSS REFERENCE INQUIRY SCREEN *** KEY IS TRANS ID, F/B POINTER, REF TRANS ID, ACCEPDATE, DOC ACTION TRANS CODE: RT TRANS NUMBER: FSC900201 DOC TOTAL: 2,198.10 OUTST AMT: 0.00 REF TRANS ID ACCEP DOC F/B/A TC NUMBER DATE ACT VENDOR AMOUNT ----- ----------------- -------- --- ------------ ----------------- 01- B MO FSCA89002 11 22 08 E 840603850 2,198.12 LAST BATCH NUMBER: CLEARING ACTION: 02- B MO FSCA89002 01 04 09 M 840603850 -0.02 LAST BATCH NUMBER: ER004 CLEARING ACTION: 03- F CV FSCA8900201 12 04 08 E 840603850 2,198.10 LAST BATCH NUMBER: CLEARING ACTION: NOTE: MO was established for $2198.12 on 11/21/08. Receiver updated FMS on 11/22/08 for $2198.12, vendor invoiced for $2198.10 (CV document) on 12/04/08. Station did modification of 0.02 on 01/04/09. Station must notify Austin to manually update the CAPPS System for the modification. 3-18

slide56

ACTION: R TABLEID: OBLH USERID: S104 FIH *** ORDERS HEADER INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER TRANS CODE: MO ORDER NUMBER: FSCA79002 TRANS TYPE: 01 SUB STN: FSC VENDOR CODE: 840603850 CONTRACT NO: AUTO ACCRUE: N NAME: WINDSOR INDS INC ALT PAYEE: / ORIGINAL AMT: 2,198.12 PO DATE: 11 21 06 AMENDMENT AMT: -0.02 LAST ACTIVITY DATE: 11 22 06 ORDERED AMT: 2,198.10 BEGIN DATE: 11 21 06 CLOSED AMT: 2,198.10 END DATE: 12 01 06 ACCRUED AMT: 0.00 NO CONTRACT MONTHS: EXPENDED AMT: 2,198.10 FOB: D OUTSTANDING AMT: 0.00 CLOSED DATE: 11 22 06 MISC REF AMT: 0.00 DISC %: 0.000 DAYS: 00 P/E TERM: 00 HOLDBACK AMT: 0.00 ADVANCED AMT: 0.00 DOC TYPE: COMMENTS: OUT ADVANCE AMT: 0.00 RESP PERSON:

NOTE: Station de-obligated 0.02 because vendor invoice was $2198.10 and receiver was $$2198.12 leaving a difference of 0.02, this amount amended the obligation.

3-19

slide61
INJURED SPOUSE EXAMPLE
  • VA referred $1808.70 debt to Treasury
  • Treasury will take $1825.70 from the spouse, $1808.70 for the debt & $17 for the fee
  • Treasury gives the VA $1808.70 and keeps the $17 fee
  • Injured spouse claims $1825.70 from the treasury
  • Treasury refunds the whole $1825.70 to the spouse
  • Treasury IPACs VA for $1825.70
  • Austin processes and advances the $1825.70 to the station
  • Station offset the $1808.70 received in #2 advance. Station also offset $17 to finish clearing advance from appropriation or MCCF.
  • Originally, the injured spouse pays the $17 fee in addition to the debt amount, which is why we need to refund it to them.
  • Stations must set up obligations first, if Treasury charges the fee of $17.00. Please see Financial Management and Accounting ALERT VOLUME 2008, ISSUE 3, dated OCTOBER 23, 2007.

3-21

3-24

injured spouse transactions example
INJURED SPOUSE TRANSACTIONS (EXAMPLE)

The below are FMS screen shots of transaction code TR

Header screen with doc total of $17.00, this is the TOPS fee.

COMMND: DOCID: TR 10 52330805025 STATUS: ACCPT

BATID: SUB STN: 09/25/09

CASH RECEIPT INPUT SCREEN

BATCH DATE: NUM DOCS: NET:

CR DATE: ACCTG PRD: ACTION: SUB STN: 523

TRANS TYPE: BFYS: FUND:

CASH ACCT: DEP NUMBER: 30705025 DOC TYPE:

BILL FUND: DOC TOTAL: 17.00

DISB OFFICE: 220 ACCOMPLISHED DATE: 09 24 09

REF DOC:

This is the two line TR. This is the amount taken from the injured spouse and the $17.00 Top fee included (which is the advanced amount). This is the amount of the IPAC from Treasury and you will see it on the ADVX table.

COMMND: DOCID: TR 10 52330805025 STATUS: ACCPT

001-002 OF 002 BATID: SUB STN: 09/25/09

LINE: 001 REF TC: DV REF DOC NO: 52330705025 REF LINE: 044

TRANS TYPE: 15 BFYS: FUND: 0160A1

STATION/SAT: 523 FCP/PRJ: JOB NO:

COST CTR/SUB: BOC/SUB: REPT CATG:

REV SRCE/SUB: CLSD BFYS: CLSD FUND:

CHECK NO: ACTION OUT: GL ACCT:

ADV IND: Y ADV: ADV NO: TRAV TYPE: VND/PRV: 104VAFC00

AMOUNT: 1825.70 I/D: I UNAPPLIED DEP NO:

AGR NO: DESCR:

The TR 75, 65 or 33 document will depend on the vendor code and fund you are using in this case it is an employee. This is the amount refunded back to the injured spouse.

LINE: 002 REF TC: REF DOC NO: REF LINE:

TRANS TYPE: 65 BFYS: 09 FUND: 0129A1

STATION/SAT: 523 FCP/PRJ: 010070701 JOB NO:

COST CTR/SUB: 570500 BOC/SUB: 1101 08 REPT CATG:

REV SRCE/SUB: CLSD BFYS: CLSD FUND:

CHECK NO: ACTION OUT: GL ACCT:

ADV IND: ADV: ADV NO: TRAV TYPE: VND/PRV: MISCN

AMOUNT: 1808.70 I/D: D UNAPPLIED DEP NO:

AGR NO: DESCR:

3-25

injured spouse transactions example63
INJURED SPOUSE TRANSACTIONS (EXAMPLE)

This TR has caused a 224 out of balance. Remember SDD number. This one line ET will balance to the TR using the same Doc ID and Direct Disbursement number (SDD number).

COMMND: DOCID: ET 10 52330705025 STATUS: ACCPT

BATID: SUB STN: 09/25/09

DIRECT DISBURSEMENT INPUT SCREEN

BATCH DATE: NUM DOCS: NET:

TRANS TYPE: DD DATE: ACCT PRD: ACTION: SUB STN: 523

BFYS: FUND: COMMENTS:

VENDOR CODE: MISCN NAME: MISC COMMERCIAL VENDOR

DIRECT DISB NO: 30705025 INTR-AGCY SYMBOL:

DISB OFFICE: 220 DOC TOTAL: 17.00

AGREEMENT NO: ADV LIQ AMT:

REF DOC NO:

The ET will allow you to reference the obligation. This is the TOP fee.

COMMND: DOCID: ET 10 52330705025 STATUS: ACCPT

001-001 OF 001 BATID: SUB STN: 09/25/09

01-

LINE: 001 REF DOC: SO 523307050 REF LINE: 001 ACCP DATE:

PAY ADV: REF ADV: REF ADV LINE: INV DATE:

VENDOR INV NO/LINE: LOG DATE:

T/T: TP BFYS: 09 FUND: 0129A1

STATION/SAT: 523 FCP/PRJ: 010070700 JOB NO:

COST CTR/SUB: 570500 BOC/SUB: 2580 REPT CATG:

REV SRCE/SUB: CLSD BFYS: CLSD FUND:

GL ACCOUNT: DESCR:

LINE AMOUNT: 17.00 I/D: I P/F: INT REASON:

LIQ AMOUNT: QUANTITY: ADV:

UNAPPLIED DEP NO:

3-26

injured spouse transactions example64
INJURED SPOUSE TRANSACTIONS (EXAMPLE)

Obligation is now expensed.

ACTION: R TABLEID: OBLH USERID: S104 FIH

*** ORDERS HEADER INQUIRY SCREEN ***

KEY IS TRANS CODE, ORDER NUMBER

TRANS CODE: SO ORDER NUMBER: 523307050 TRANS TYPE: 01 SUB STN: 523

VENDOR CODE: MISCN CONTRACT NO: AUTO ACCRUE: N

NAME: MISC COMMERCIAL VENDOR

ALT PAYEE: /

ORIGINAL AMT: 17.00 PO DATE: 09 24 09

AMENDMENT AMT: 0.00 LAST ACTIVITY DATE: 09 24 09

ORDERED AMT: 17.00 BEGIN DATE: 09 24 09

CLOSED AMT: 17.00 END DATE: 09 24 09

ACCRUED AMT: 0.00 NO CONTRACT MONTHS:

EXPENDED AMT: 17.00 FOB:

OUTSTANDING AMT: 0.00 CLOSED DATE: 09 24 09

MISC REF AMT: 0.00 DISC %: 0.000 DAYS: 00 P/E TERM: 00

HOLDBACK AMT: 0.00

ADVANCED AMT: 0.00 DOC TYPE: COMMENTS:

OUT ADVANCE AMT: 0.00 RESP PERSON:

3-27

dms application suite create helpdesk tickets
DMS Application SuiteCreate Helpdesk Tickets
  • SQL Launcher
  • Treasury Offset
  • Obligation History
  • Payment History
  • Vendor EFT Compliance
  • Library View
  • Local Accounting

3-29

slide67

Treasury Offset Program (TOP)

The Financial Services Center (FSC), Financial Accounting Service (FAS), Accounting, Reconciliation & Reports Division (ARRD) will record a transaction (OS-15) in the Financial Management System (FMS), which notifies field facilities when one of their payments has been offset by TOP.

The FMS OS-15 transaction records a zero dollar amount to Standard General Ledger accounts 99D1 and 99D2 and reference the payment obligation.

Additionally, the transaction is reflected on field facilities’ daily Accepted Document Listing (RGSADLV – F829) and on FMS research tables (DXRF, PVHT/PVLT, GLDB). Since the OS-15 records a zero dollar amount, the offset amount and agency information is reflected in the invoice number field of the transaction. For example, VENDOR INV: TOP- $300.00 – IRS.

In some cases, the TOP offset may affect several payments to a vendor on the same day. In that case, the OS-15 is recorded to one payment/obligation and the total amount of the offset reflected in the invoice number field. The OS document number reflects the same document number, which was offset by TOP.

3-30

accounts receivables reports
Accounts Receivables Reports
  • F853 run on the EOM and 10th WD

REPORT NAME-> CD.RARVGLV.OCT07 FORM-> F853

VERIFICATION OF GENERAL LEDGER BALANCES – ACCOUNTS

RECEIVABLE FEDERAL/NON-FEDERAL REPORT

  • F842 run on the EOM and 10th WD

REPORT NAME-> CD.RARABRV.OCT07 FORM-> F842

AGING ACCOUNTS RECEIVABLE REPORT

3-31

f853 verification of general ledger balances accounts receivable federal non federal report
F853 Verification of General Ledger Balances – Accounts Receivable Federal/Non-Federal Report

RARVGLV 306 0151A1

REPORT ID: RARVGLV *** DEPT OF VETERANS AFFAIRS (FMS) *** PAGE: 4

RSD FORM: F853 VERIFICATION OF GENERAL LEDGER BALANCES - ACCOUNTS RECEIVABLE TIME: 23:40

RUN DATE: 11/15/09 FEDERAL/NON-FEDERAL REPORT AS OF 11/15/09

STN: 306 BFYS: 10 FUND: 0151A1 PAYOR TYPE CATEGORY: NON-FEDERAL

NEW YORK NY VARO GOE - CAT A - LMT 01 A/O: 20

VETERANS BENEFITS ADMIN

REV LAST ACT

DOCUMENT ID LINE FCP/PRJ BOC SRCE REF DOC ID LINE DATE DATE PAYOR CODE NAME OUTSTANDING AMOUNT

----------------------- ----- -------------- ------- ----------------------------- ----------------- ------------- --------------------- ------------------- -------------------------------------

BD 3069FSC6933 001 013 1132 10/06/09 10/23/09 FEHBLWOP FEHBLWOP 228.89

BD 3069FSC5494 001 013 1132 10/06/09 11/03/09 FEHBLWOP FEHBLWOP 595.18

NUMBER OF RECORDS: 2 STN 306 SUBTOTAL AMOUNT: 824.07

OUTSTANDING AMOUNT

-------------------

ACCOUNTS RECEIVABLE TOTAL: 824.07

G/L ACCOUNT BALANCES:

G/L G/L

ACCT ACCT NAME BALANCE

-------- ------------------- ---------------

1313 AR-REFD-OTH 824.07

G/L TOTAL: 824.07

DIFFERENCE: 0.00

3-32

f842 aging accounts receivables
F842 Aging Accounts Receivables

RSD FORM: F842 AGING ACCOUNTS RECEIVABLE REPORT TIME: 23:40

RUN DATE: 11/15/09 AS OF 11/15/09

STN: 306 FUND: 0151A1 BFY: 10 PAYOR TYPE CATEGORY: NON-FEDERAL

NEW YORK NY VARO GOE - CAT A - LMT 01

AGING DOCUMENT ESTAB LAST ACTV DAYS ORIGINAL COLLECTED WRITE-OFF BALANCE PAYOR VENDOR/

CATEGORY NUMBER DATE DATE LATE AMOUNT AMOUNT AMOUNT DUE CODE EMPLOYEE NAME

-------- ------------- -------- -------- ----- -------------- -------------- ------------ -------------- ----------- ---------------

NOT DELQ BD3060FSCL6933 10/06/09 10/23/09 0 228.89 228.89 FEHBLWOP FEHBLWOP

NOT DELQ BD3060FSC5494 10/06/09 11/03/09 0 595.18 595.18 FEHBLWOP FEHBLWOP

NOT DELQ SUBTOTAL: 824.07 824.07

STN: 306 FUND: 0151A1 BFY: 10 TOTAL: 824.07 824.07

NUMBER OF RECORDS: 2 STN: 306 TOTAL: 824.07 824.07

3-33

slide71

Section 3a

Account Payables

slide72

What is a Receiver document?

  • The Receiver document is an important facet of the FMS purchasing cycle. VA will use this document
  • to record the receipt and acceptance of goods. In addition, the receiver updates the FMS system
  • tables upon document acceptance, providing accurate, up-to-the-minute information on the status
  • of funds.
  • There are 3 types of Receiver documents used for this purpose:
  • 1. RT document – records the receipt and acceptance of goods with a Document Locator Number
  • (DLN), maintaining accrual information for goods, and posting the accrued expenditure and liquidating
  • the referenced obligation.
  • Scenario – The VA obligates funds for the purchase of supplies. The supplies are received, but the
  • entire order is not filled. A receiver document is processed referencing the obligation and recording
  • a DLN to show the partial receipt of supplies.
  • 2. RC document – records the receipt and acceptance of goods without a DLN, maintaining accrual
  • information for goods, and posting the accrued expenditure and liquidating the referenced obligation.
  • Scenario – The VA obligates funds for the purchase of supplies from another government agency.
  • The supplies are received, but the entire order is not filled. A receiver document is processed
  • referencing the obligation and not recording a DLN to show the partial receipt of supplies.
  • 3. AR document – used for posting the accrued expenditure and liquidating the referenced obligation.
  • Generated by SO, CO, and AO documents, if entered with an auto accrue flag of “Y”. AR documents
  • can also be entered manually when the auto accrue flag on the obligation document is “N”.
  • Scenario – The VA obligates funds for an elevator maintenance contract. The contract spans twelve
  • months. At the end of each month, the system will automatically generate an accrual for this
  • obligation. The system will reverse the accrual at the beginning of the following month.

3a-1

slide74

*ITS VERY IMPORTANT TO ENTER THE DATE THAT THE GOODS WERE ACTUALLY RECEIVED. IF A RECEIVED DATE IS FROM A PRIOR MONTH THAN CURRENTLY PROCESSING, YOU WILL NEED TO ENTER THE CURRENT ACCOUNTING PERIOD (ACCT PRD:) FIELD.

3a-3

slide75
Invoice is received
    • Payment person verifies goods were received by reviewing RC/RT or AR entry in FMS
    • Once validated, a PV 01 transaction entry into FMS is accomplished
    • If this is the final payment ensure an “F” is annotated in the field P/F
      • This automatically zeros out any amount left on the obligation

3a-4

slide76
Invoice is received
    • Payment person verifies goods were received by reviewing RC/RT or AR entry in FMS
    • Payment person enters a PV 01 transaction into FMS
      • A “F” was not annotated in the field P/F and it was the final payment
      • To clear the obligation a zero PV 01 payment transaction into FMS is required with an “F” in

the P/F field.

3a-5

slide77

Example of the “F” not being entered

ACTION: R TABLEID: RCLA USERID: S104 RMJ                                      

                 *** RECEIVER ACCOUNTING LINE INQUIRY SCREEN ***               

 KEY IS TRANSACTION CODE, RECEIVER NUMBER, ACCOUNTING LINE NUMBER              

 TRANSACTION CODE: RC       RECEIVER NO: 523A0999901                           

 01-      LINE NO: 001      REF LINE NO: 001     TRANS TYPE: 01                

             BFYS: 10              FUND: 0160A1 STATION/SAT: 523     /         

     COST CTR/SUB: 827200  /    FCP/PRJ: 010022300  BOC/SUB: 2580 /            

           JOB NO:            RPTG CATG:        ACCRUAL AMT:            500.00 

        CLSD BFYS:            CLSD FUND:        VOUCHER AMT:            500.00 

            DESCR:                                  LIQ AMT:            499.00 

OUTST AMT:              1.00 

                                                 CLOSED AMT:            499.00 

 02-      LINE NO:          REF LINE NO:         TRANS TYPE:                   

COMMND:                 DOCID: PV 10   523A0999902            STATUS: ACCPT   

001-001 OF 001          BATID:                   SUB STN:          08/03/07   

3a-6

slide78

Example of the Zero PV 01 Payment Screen

COMMND:                 DOCID: PV 10   523A9999902            STATUS: ACCPT   

001-001 OF 001          BATID:                   SUB STN:          08/03/09   

                        PAYMENT VOUCHER INPUT SCREEN                          

  TRANS TYPE: 01  PV DATE:           ACCT PRD:       ACTION:   SUB STN: 104   

 VENDOR CODE: 132646870                  NAME: HOWMEDICA INC                  

 BENEFICIARY:              PPAY TYPE:   ADDR1: P O BOX 100753                 

 SCHD PMT DATE:          FISCAL APRV:   ADDR2:                                

     DOC TOTAL: 0.00              CITY/ST/ZIP: ATLANTA             GA 30384   

    CHECK TYPE:      COMMENT TO PRINT:                                        

        DISC %:          DAYS:      P/E TERM:      AMT:                       

        DISC %:          DAYS:      P/E TERM:      AMT:                       

01-                                                                           

    LINE: 001 REF DOC: RC 523A9999901   REF LINE: 001   ACCP/DEL DATE:        

       VENDOR INV: WR                   INV DATE: 08 09 09   LOG DATE: 08 09 09

    REF VEND CODE:              REF VEND NAME:                                

      LINE AMOUNT: 0.00            I/D:   P/F: F UNAPPL DEP NO:               

       LIQ AMOUNT:                      DESCR:                                

      OUTST OBLIG:            0.00  LINE TYPE:    INT RSN:   DISC RSN:        

             BFYS: 09                    FUND: 0160A1                          

      STATION/SAT: 523                FCP/PRJ: 010022300       JOB NO:        

     COST CTR/SUB: 827200             BOC/SUB: 2580         REPT CATG:        

     REV SRCE/SUB:                  CLSD BFYS:              CLSD FUND:        

Make sure to fill out everything that is filled out in the example above

3a-7

slide79

Results of the Zero PV 01 Payment

ACTION: R TABLEID: RCLA USERID: S104 RMJ                                      

                 *** RECEIVER ACCOUNTING LINE INQUIRY SCREEN ***               

 KEY IS TRANSACTION CODE, RECEIVER NUMBER, ACCOUNTING LINE NUMBER              

 TRANSACTION CODE: RC       RECEIVER NO: 523A9999901                           

 01-      LINE NO: 001      REF LINE NO: 001     TRANS TYPE: 01                

             BFYS: 09              FUND: 0160A1 STATION/SAT: 523     /         

     COST CTR/SUB: 827200  /    FCP/PRJ: 010022300  BOC/SUB: 2580 /            

           JOB NO:            RPTG CATG:        ACCRUAL AMT:            499.00 

        CLSD BFYS:            CLSD FUND:        VOUCHER AMT:            499.00 

            DESCR:                                  LIQ AMT:            500.00 

OUTST AMT:              0.00 

                                                 CLOSED AMT:            499.00 

 02-      LINE NO:          REF LINE NO:         TRANS TYPE:                     

3a-8

slide80

F851 Report

This is a good report to watch for outstanding amounts and how long it has been open

RPEVGLV STA 0160X4

REPORT ID: RPEVGLV *** DEPT OF VETERANS AFFAIRS (FMS) *** PAGE: 1

RSD FORM: F851 VERIFICATION OF GENERAL LEDGER BALANCES - PAYABLES TIME: 23:03

RUN DATE: 07/31/09 FEDERAL/NON-FEDERAL REPORT AS OF 07/31/09

STN: STA BFYS: 94 FUND: 0160X4 PAYABLE TYPE: ACCOUNTS PAYABLE

Austin VAMC A/O: 10 MEDICAL SVCS - MCCF VEN TYPE CAT: NON-FEDERAL

VETERANS HEALTH ADMIN.

DOCUMENT ID FCP/PROJ VENDOR CODE NAME DATE DYS OPEN ACCRUAL AMOUNT VOUCHERED AMOUNT OUTSTANDING AMOUNT

-------------- --------- ----------- --------------- -------- -------- ------------------- ------------------- -------------------

RT STAL9000102 01HC20600 592663954 OFFICE DEPOT IN 11/13/08 260 198.99 179.10 19.89

RT STAL9001101 01HC34300 541458884 CAPITOL BUILDIN 05/31/08 61 2,228.59 1,883.42 345.17

RT STAL9001301 01HC34300 541458884 CAPITOL BUILDIN 04/26/08 96 1,323.00 1,290.70 32.30

NUMBER OF RECORDS: 3 STN 688 SUBTOTAL: 3,750.58 3,353.22 397.36

PAYABLES TOTALS: 3,750.58 3,353.22 397.36

3a-9

slide81
Other uses for the zero PV 01
    • Clear an MO or SO with an outstanding amount
      • To clear the obligation a zero PV 01 payment transaction into FMS is required
      • Reference the MO or SO document
      • Enter “F” in the P/F field
      • F850 report is a good resource to review

3a-10

slide82

Section 4

Payroll Transactions/Expenditures

fms error table errg
FMS ERROR TABLE ERRG

ACTION: R TABLEID: ERRG USERID: S104 RMJ

*** ERROR GUIDE INQUIRY TABLE ***

KEY IS ERROR CODE

ERROR CODE: SC08E ERROR MESSAGE: SUBALLOW SPEND CTL NOT FOUND

PROBLEM:

NO ENTRY IN THE SUBALLOWANCE SPENDING CONTROL TABLE (SASP)

WAS FOUND.

SOLUTION:

SPECIFY A DIFFERENT SUBALLOWANCE CODE OR HAVE THE GIVEN

SUBALLOWANCE ESTABLISHED.

4-7

fms table errg
FMS TABLE ERRG

ACTION: R TABLEID: ERRG USERID: S104 FSC

*** ERROR GUIDE INQUIRY TABLE ***

KEY IS ERROR CODE

ERROR CODE: SC06W ERROR MESSAGE: INSUFFICIENT ALLOWANCE FUNDS

PROBLEM:

THIS IS A WARNING MESSAGE. THE TRANSACTION EXCEEDS THE

AVAILABLE ALLOWANCE FUNDS.

SOLUTION:

REVIEW THE ALLOWANCE AND CONTROL OPTIONS.

4-10

slide110

Section 5

TDY Travel

slide118

COMMND: DOCID: TV 10 635T9023401 STATUS: ACCPT

004-004 OF 001 BATID: SUB STN: 10/14/09

01-

LINE: 001 REF DOC: TO 635T00234 REF LINE: 001

LINE TYPE: E TAX TYPE: TRAVEL TYPE: TDY

EXCEPTION: I/D: EXC CODE: DESCR CODE: E

LINE AMOUNT: 813.32 I/D: P/F: F TAX CODE:

LIQ AMOUNT: 1699.00 DESCR: TVL 11/03/2009 TO 11/09/2009

BFYS: 10 FUND: 0160A1

STATION/SAT: 635 / FCP/PRJ: 010040316 JOB NO:

COST CTR/SUB: 824100 / BOC/SUB: 2104 / REPT CATG:

CLSD BFYS: CLSD FUND:

01-CVYTW-EXCEEDED LOWER LIMIT LIQ TOL

5-8

slide148

Section 6

Financial Indicators

slide155

Section 7

F911 Report vs Macro

slide156

Accessing Ken Hudson Financial Macros through Sharepoint

  • 1. Go to: http://vaww.vha.vaco.portal.va.gov/sites/OF/CFOFO
  • If you do not have access to this Sharepoint, you will receive an “Error: Access Denied”.
  • Click on the “Request Access” link displayed on the page and follow the instructions.
  • Shortly after, you should receive an email with permission to access the Sharepoint Site.
  • 2. Once on the site:
  • Click on “Shared Documents” on the list to the right.
  • Click on “Monthly Recon Macros for Office 2007” (or 2003 if you are using MS Office Suite 2003)
  • Click on “F911_V12.4_2007”
  • 3. Once the spreadsheet is downloaded you have to enable the Macro Content.
  • Click on “Options” in the Security tab.
  • Click on “Enable Content” then click “OK”.
  • Follow the instructions on the Macro to download your F911 report from RSD.
  • All requests for new Financial Macros and the management of all existing Financial Macros in the “Shared Documents” should be sent to Ms. Yong Osborne at yong.osborne@va.gov or #512-326-6827.

7-1

slide159

COMMON F911 VS MACRO ISSUES

As noted in each station's worksheet, please be advised that if the normal entry is a C4 or D4 and the BFY is prior year, the actual account balance can be opposite of the normal balance if it was caused by specific prior year transactions; however, each facility needs to review each account listed in their worksheet and determine the cause of the abnormality and take necessary corrective actions, accordingly.  A brief description of the corrective action taken on each abnormal balance should be documented using the "insert", "comment" option in the excel worksheet. Kindly collect the completed worksheets directly from your facilities and have the file sent back to "VHA CFO Financial Analyses Shared Mailbox" with your VISN number on the subject line.

Abnormal balances in SGL accounts 1319, 1329, 1339, and 1369 Kindly be advised that the Central Office is currently responsible for recording allowance for bad debt for non-healthcare receivable. CO will process a SV to correct the abnormality. Until this function returns to facilities we are asking facilities not make any adjustments into the allowance accounts (SGL) 1319, 1329, 1339, and 1369 for Funds 1435, 3220, 3200, and AMAF except the normal write off transactions. Questions concerning this request should be forwarded to "VHA CFO Financial Analyses Shared Mailbox" or you may call Sylvia Nieto at 202-461-6567.. Stations should not reverse the SVs processed by CO.

Debit balances in account 490F – These typically occur because of payments going in as Federal vendor ID number get changed to Non-Federal and when the AD hits it causes the abnormal balances. A BL transaction can be done by FSC Accountants. Send a JV request to debit 490N and credit 490F for the amount. The 490N balance is supposed to be in agreement with all of the non-federal payables (2000 series) accounts. SendJV (1017 form) to FSC Accountant. Because these are budgetary accounts, reference the Cost Center/Accounting Classification Code/Fund Control Point/Budget Object Code to use for the entry.

Debit balances in account 490G – These typically occur because of expenditure transfer transactions between funds that use the station’s vendor ID instead of the non-federal vendor ID against which the initial expenditures were processed.  Expenditure transfers with a federal vendor ID post to 490G while transfers using a non-federal ID post to 490P.  IFCAP uses the station vendor ID instead of the US Bank ID on credit card ET transactions so stations can’t prevent debits in 490G resulting from credit card ETs.  For other types of expenditure transfers, stations can eliminate this problem by using the actual vendor ID or MISCN.  To correct existing debits, stations can identify expenditure transfers that created the problems, reverse them and repost them with the correct vendor ID or MISCN.

Balances in GL 1099 & 5239 in the invalid MCCF Funds – As canceled checks are processed related to refund payments made from the old MCCF fund structure (5287, 5287.1, 5287.3, 5287.4), the GL transactions post against those invalid funds.  These balances should be cleared by moving them to the appropriate MCCF fund in the new base BFY 05 fund structure (e.g. 528701, 528703, 528704, etc).  To accomplish this, create a JV form (1017) with the entries needed to reverse the balances from the improper fund and move them into the correct fund. The JV should also include revenue source code(s) as they are required for a JV in FMS.  The JV form should be submitted to station’s FSC trial balance accountant for approval and processing.

7-4

slide160

COMMON F911 VS MACRO ISSUES

Subject: Procedure to change vendor for credit card reconciliation ET transactions

Sandra Cole sent me the instructions below on how to change the vendor for IFCAP generated ET transactions.  The change has worked successfully for her station and another station that we service.  Please consider making this change as it will keep the 490G issue related to credit card reconciliations from continuing to be a problem.

The credit card ET transaction vendor code (Sta. ID) can be changed to the US Bank vendor code (310841368) in the IFCAP Coordinator Site Parameter.

MS SECURITY CODE: 10// FISCAL REVIEW OF VRQ: NO// CARRY FORWARD 4TH QTR REQUESTS: NO// FMS-ET VENDOR CODE: 546VAH000// 460358360FMS-ET ALTERNATE ADDRESS IND.: RANGE OF % FOR RECONCILING AMT: 0// STATION NUMBER:

Select IFCAP Application Coordinator Menu Option:

Subject: RE: Improper balances in 490G/490P from expenditure transfers

As noted in my original message, the ET transactions generated by credit card reconciliations in IFCAP improperly post against 490G in FMS.  The number of credit card ET transactions generated at stations will likely make it difficult to correct the debit balance related to them.  The question has come up from stations that have corrected their debit balances from other sources, but are concerned about the time needed to research the credit card ET transactions.  Although clearing these improper 490G balances should be accomplished if possible, it is not expected to be completed for remaining balances determined to be related to credit card ET transactions.

Subject: Improper balances in 490G/490P from expenditure transfers

Improper balances in the 490G and 490P accounts have been more of an issue this year.  Most of these balances are the result of expenditure transfers between funds (EW) or stations (EB) that use the station’s vendor ID instead of the vendor ID recorded on the initial expenditure transaction.  In most cases the initial expenditure was to a non-federal source so the posting was a credit to 490P.  When the transfer is recorded with the station’s vendor ID, the posting debits 490G on the side transferring the cost and credits 490G on the side receiving the cost.  This results in an improper 490G balance.

Expenditure transfers should use the vendor ID from the initial expenditure transaction whenever possible.  For lump sum expenditure transactions of non-federal expenditures, using MISCN will also properly post against 490P.

The other known problem in this area is the ET transactions generated by purchase card reconciliations in IFCAP.  They post against 490G while the credit card transactions use the US Bank vendor ID and post to 490P.  This is not an issue if the ET just moves the charge between FCP/ACCs within a fund as the posting to 490G will net out on the trial balance.  It is an issue when these ET transactions move charges between BFYs or funds as it leaves the improper 490G balances.

7-5

slide161

Other possibilities:

Kindly consider the following steps for correcting abnormal balances due to contract holdbacks:

1. Check FMS table GLTS if you find debt on 2122 and credit on 2121 or 2130 Station needs to research.

2. Research and identify the document that caused the problem.

3. Prepare 1017G journal voucher form and send to NAS Accountant for processing.

Balances in accrued salaries GL 2210 in expired years (both debits and credits) SV 51

Offsetting balances in GL 2121 and 2122

Debit balances in GL 2994

The normal nationwide balance for GL 422B is a debit, but the station balance is normally a credit. We haven’t received a

response on whether this needs to be corrected. Since the nationwide balance is a debit anyway, ignore this item until

Supply Fund requests thecorrections.

Other items:

Footnotes to the chart for GL accounts that can have opposite balances in expired years. Some of the most frequent

examples of this are GL accts like 3107, 490G, 490P, 5200, 5201, 5700 and 6100.

.

7-6

slide162

The 5114 and 5115 (MCCF 5287**) improper balances are because the reversal of the 9/30/08 accrual entry for these in October was probably greater than the accrual entry posted at the end of the current month. Financial Policy is requesting a change in the accrual process at yearend to resolve this problem for FY09. Proposal is for the SV17 and SV 18 accrual transaction to reverse for all months except for the end of September accrual. That accrual will not reverse in early October eliminating the improper balance issue for this account.

7-7

slide163

The FMS transaction group completed its 2006 review of the FMS Proforma Transactions. One item on the agenda was the mixture

of revenue accounts being used on the MCCF (5287**) transactions in fund category M. Some of the transactions in this

category date back to the time prior to the 5287 point accounts when VA was required to return most of these collections to

Treasury. The revenue transactions at that time used GL accounts 5902, 5903, and 5909 in the other revenue account series

similar to the transactions in the Treasury GFR funds like 1435 and 3220. With the implementation of the 5287** point account

structure and VA retaining these collections, many of the more recently added transactions in this fund category use GL 5200

and 5201. One problem arising from the use of these two sets of revenue accounts in improper balances remaining after posting

collection activity. Examples from stations of situations include where a receivable was established that posted

to GL 5201 in FY 05, but the collection transaction posted to GL 5902 in FY 06 resulting in an improper balance in GL 5201.

In an effort to resolve this problem for future years and make the MCCF revenue postings more consistent, all of the transactions

In fund category M that post to GL 5902, 5903, and 5909 were changed as listed below:

All transactions with GL 5902 now use GL 5201

All transactions with GL 5903 now use GL 5200

All transactions with GL 5909 now use GL 5239

GL 5239 is a new account in FMS which was established to replace GL 5909 for tracking refunds of collections.

7-8

slide165

Section 8

Annual Close Memo

closing the books
CLOSING THE BOOKS
  • 5000, 6000, AND 7000 3310
  • ANNUAL APPROP. 4610 4650
  • ALL DISBURSING AUTHORITY ACCOUNTS CLOSE TO 1010

9-1

closing the books168
CLOSING THE BOOKS

The following Budgetary Accounts willNOT CLOSE at the end of the Year:

  • 425F Reimbursements - Fed Receivable
  • 490F - Unpaid Expended Authority - Federal
  • 490N - Unpaid Expended Authority - Public

9-2

closing the books169
CLOSING THE BOOKS
  • BFY and Ending BFY 05 Travel Obligations - Must be Reversed
    • BFY 05 and Ending BFY 05 Advances - Collect, Write off or Reclassify
    • BFY 05 and Ending BFY 05 Receivables - Moved to 3200 during annual close
    • BFY 05 and Ending BFY 05 WIP - Review and move as necessary

9-3

closing the books170
CLOSING THE BOOKS
  • Ensure Manual accruals have a reversal period of 01/11
  • FY10 TriCare bills are moved to FY11
  • Ensure available unobligated balances have sufficient funds to cover G/L 1321

9-4

trial balance
TRIAL BALANCE
  • COMMON QUESTIONS/PROBLEMS
    • Allowance accounts must have a Credit Balance
    • WIP must be a Debit Balance and should not be in AMAF
    • Liability accounts (2XXX) must have a Credit Balance
    • 48XX - Should always “net” to a Credit balance in both CY and PY

9-5

trial balance172
TRIAL BALANCE
  • COMMON QUESTIONS/PROBLEMS
    • 49XX - Should always “net” to a Credit balance in CY
      • PY may be Debit balance due to adjustments
    • 5XXX - Should always be a Credit balance in CY
      • PY may be Debit balance due to adjustments
    • 6XXX - Should always be a Debit balance in CY
      • PY may be a Credit balance due to adjustments

9-6

slide173

Section 10

Journal Vouchers (JVs)

slide174

JOURNAL VOUCHER (OF 1017-G)

a. OF 1017-G will be used for the following purposes:

(1) To document expenditure transfers and adjustments between appropriation, fund and receipt accounts which affect a single VA station.

(2) To document general ledger transactions when it is not feasible to make entries from journals or basic documents. Likewise, adjustments of previous ledger entries will be made through the medium of OF 1017-G.

(3) To document accruals and in transit transactions at the close of the month. The transactions will be either listed and totaled on the OF 1017-G or worksheet attached thereto. This same document can be used to record reversal of transactions at the beginning of the subsequent month.

(4) To document Supply Fund cash sales to support the SF 224, Statement of Transactions. The form will be prepared monthly marked "memo record for file". It will not be posted to the accounting records.

b. OF's 1017-G will be assigned by the same employees authorized to certify SF's 1081 (par. 2C.04h). A full and complete description of the transaction will be made and the voucher will be conspicuously marked "EXPENDITURE TRANSFER" or "ADJUSTMENT," indicating the nature of the document. Each voucher will be adequately described and supported by working papers cross-referenced to documents or accounts when necessary for full clarification.

c. OF's 1017-G will not be submitted to the Treasury, however, they will be reported in section I of the SF 224, and both the charge and credit amounts must agree. All OF's 1017-G prepared between ALC 36001200 CALM and other VA agency location codes will be processed and reported on the CALM SF 224 report. The original OF 1017-G must be forwarded to the Austin DPC (362B1) no later than the 22d calendar day of the month.

d. OF 1017-G will be prepared in an original only.

10-1

slide176
ACTION: R TABLEID: PVHT USERID: S104 FSC                                      

                      *** VOUCHER HEADER INQUIRY SCREEN ***                    

KEY IS VENDOR CODE, TRANS CODE, VOUCHER NO, TRAVEL ADV NO                     

VENDOR CODE: 952802182        TRANS CODE: ET    VOUCHER NO: 104JV1276

NAME: SIEMENS MED SOLUTIONS DIAGS IN  TRAVEL ADV NO:                 

ADDR1: SIEMENS DIAGS PRODS               NO CHK DISB: N               

ADDR2: 5210 PACIFIC CONCOURSE DR                D.O.: 220             

ADDR3:                                        FA IND:                 

CITY/ST/ZIP: LOS ANGELESCA 900455544    OCR PRINT: N               

DESCRIPTION:              PROMPT PAY TYPE:      CHECK TYPE: N               

VOUCHER TYPE: 1  FEE CODE:            CORSPDNCE VENDOR CODE:                 

AGREEMENT NO:                  FORCE CHECK: N   DISB RUN NO: 00000           

SCHD FISC YR:    SCHD CATG:      SCHD TYPE:         SCHD NO:                 

VOUCHER DATE: 05 28 09  MANUAL ADDR CHANGE: N   VOUCHER AMT:               0.00

SCHD DATE:                  FISCAL APRV:    HOLDBACK AMT:               0.00

CLOSED DATE: 05 28 09   DISB INFO CHANGED: N    CLOSED AMT:              0.00

BENEFICIARY:                                     OUTST AMT:               0.00

ACCT STN: *******    SUBMIT STN: 104     N TRANSIT AMT:               0.00

DIRECT DISB NO: JV1276                     ADV LIQ AMT:              0.00

INTR AGCY SYMBOL:                                LIQ AMT:              0.00

COMMENTS TO PRINT:                                                         

DISC %/DAYS/PE TERM:  0.000 / 00 / 00 ;  0.000 / 00 / 00 ;  0.000 / 00 / 00   

10-3

slide177
ACTION: R TABLEID: PVLT USERID: S104 AFA                                      

                        *** VOUCHER LINE INQUIRY SCREEN ***                    

KEY IS VENDOR CODE, TRANS CODE, VOUCHER NUMBER, TRAVEL ADV NUMBER, LINE NUMBER

VENDOR CODE: 952802182     TRANS CODE: ET     VOUCHER NO: 104JV1276

TRAVEL ADV NO:                                                               

LINE NO: 001      VENDOR INV:                      VI LINE NO:          

INV DATE:            LOG DATE:                   ACCP/DEL DATE:          

BFYS: 09             FUND: 0160A1               TRANS TYPE: 01

ADM/OFF: 10      STATION/SAT: 612            LINE AMT:          2,735.78

FCP/PRJ: 010022300    JOB NO:              CLOSED AMT:          2,735.78

COST CTR/SUB: 822300  00  BOC/SUB: 2631           DISB AMT:          2,735.78

REV SRCE/SUB:            REPT CAT:          IN TRANSIT AMT:              0.00

REF DOC NO: SO 612C91068     REF DOC LINE: 001 ADV LIQ AMT:        0.00

REF ADV NO:                  REF ADV LINE:         LIQ AMT:          2,735.78

PAY ADV:    ADV:     OVRD ACCT:        CLSD BFYS:        CLSD FUND:       

DESCRIPTION: PD607C90076                          OVERRIDE OFFSET ACCT:       

RELATED GBL:                 QTY:        0.00               PROMPT PAY: N     

DISCOUNT %/DAYS:  0.000 / 00 DISC LOST RSN CODE:       INTEREST REASON:       

UNAPPLIED DEPOSIT NO:                                                         

CT 607C9007607 hit obligation SO 607C90076 (incorrect one). Line 001 is moving expense to obligation SO 612C91068 (the correct one), which is being referenced in the above document.

10-4

slide178
ACTION: R TABLEID: PVLT USERID: S104 FSC                                      

                        *** VOUCHER LINE INQUIRY SCREEN ***                    

KEY IS VENDOR CODE, TRANS CODE, VOUCHER NUMBER, TRAVEL ADV NUMBER, LINE NUMBER

VENDOR CODE: 952802182     TRANS CODE: ET     VOUCHER NO: 104JV1276          

TRAVEL ADV NO:                                                               

LINE NO: 002      VENDOR INV:                      VI LINE NO:          

INV DATE:            LOG DATE:                   ACCP/DEL DATE:          

BFYS: 09             FUND: 0160A1               TRANS TYPE: 01

ADM/OFF: 10      STATION/SAT: 607            LINE AMT:        -2,735.78

FCP/PRJ: 0100224V1    JOB NO:              CLOSED AMT:          -2,735.78

COST CTR/SUB: 822400  00  BOC/SUB: 2592           DISB AMT:          -2,735.78

REV SRCE/SUB:            REPT CAT:          IN TRANSIT AMT:              0.00

REF DOC NO: SO 607C90076     REF DOC LINE: 001 ADV LIQ AMT:          0.00

REF ADV NO:                  REF ADV LINE:        LIQ AMT:        -2,735.78

PAY ADV:    ADV:     OVRD ACCT:        CLSD BFYS:        CLSD FUND:       

DESCRIPTION: S/B612C91068                         OVERRIDE OFFSET ACCT:       

RELATED GBL:                 QTY:        0.00               PROMPT PAY: N     

DISCOUNT %/DAYS:  0.000 / 00 DISC LOST RSN CODE:       INTEREST REASON:       

UNAPPLIED DEPOSIT NO:  

Line 002 is returning funds back to SO 607C90076.

10-5