Category: Training

Dormant MORD Performance Countermeasures

In response to recommended process improvements, the 31 December 2022 deobligations will be limited to dormant Accounting MORDs marked as “deobligate” in PowerBI. MORDs without comment in PowerBI, meeting the criteria in the Performance Metric Countermeasures Memo signed on 4 Nov 2022 will not be deobligated on 31 December 2022. Dormant MORD Performance Countermeasures

Performance Metric Countermeasures for
Dormant Accounting Miscellaneous Obligation Reimbursement Documents (MORDs)​​​​​​​

16 DECEMBER 2022 UPDATE: In response to recommended process improvements, the 31 December 2022 deobligations will be limited to dormant Accounting MORDs marked as “deobligate” in PowerBI. MORDs without comment in PowerBI, meeting the criteria for the Performance Metric Countermeasures for Dormant Accounting MORDs policy signed on 4 Nov 2022 will not be deobligated on 31 December 2022. Additional training on the process will be made available in January 2023 and monthly deobligations will continue as originally planned.

In accordance with the 4 November 2022 Air Force Accounting & Finance Office – Accounting (AFAFO-A) Performance Metric Countermeasures memo to establish a process to deobligate aged Accounting MORDs within DEAMS that are dormant for 180 days or more, the AFAOC has identified the specific documents that require research, validation and/or corrective action. The results have been consolidated and delivered as a new tool within the Open Documents portion of AFAOC Data Analytics PowerBI application entitled “DEAMS Dormant POs” located on the Data Analytics and Field Support SharePoint site. This module is updated daily and a training video will be made available soon for reference.

All bases should access the DEAMS Dormant POs application and take appropriate action IAW the instructions provided in the policy memo to either deobligate the MORD or provide an explanation for keeping the obligation balance open.  Any dormant MORDS  meeting the criteria established by AFAFO-A  (FY20 or older) will be systemically deobligated on 31 December 2022 and will continue to be deobligated monthly.  Bases will be required to review and validate dormant MORDs on a monthly basis until they are no longer open.

The DEAMS Dormant POs tool provides an “Age Band” filter, which allows users to view documents based on the number of days since last accounting activity. Users can select multiple age ranges from 61-90 days; 91-120 days; 121-150 days; 151-180 days; and 181+ days.

It is the base’s responsibility to ensure their open MORDs aged 180 days, or more are validated prior to the end of each month. To reserve the obligation, a MORD must be annotated with “Valid Obligation” within the PowerBi tool before the end of the month, along with all the following details:

Reason for the delay in expensing the obligation
A generic response WILL NOT be accepted; if this was processed as a TBO include the associated voucher information

Amount of the pending invoice
If the invoice is less than the MORD, you will need to decrease your MORD

Anticipated expenditure date
Documentation to support this date must be uploaded in FMSuite

Source of invoice
Performing organization or Vendor’s contact information is required

Note: MAJCOMs/FIELDCOMs are responsible for providing guidance on whether MAJCOM/FIELDCOM approval is required to keep the obligation in the system.

Thoughts on Budgeting

  • The concern should be to make the budget as realistic and accurate as possible because a reasonable budget based on a reasonable plan encourages reasonable performance
  • A budget is a measurement tool; accountability, discipline and reviews are necessary for control
  • A budget requires complete participation by all levels of management
  • Large variances between planned performance and budget objectives indicate a weakness in one or multiple areas:
    • Poor estimates
    • Poor feedback and lack of timely, corrective action
    • Ineffective management policies concerning budget maintenance
  • Know your operation. Know the people in your operation. Seek feedback. Experience your mission hands-on.
    • Don’t gloss over this. Get to know each of your missions intimately
      • How many supplies does each unit have available?
      • Where are the supplies stored? Are they controlled? Are folks scraping by unnecessarily?
      • Do you have excess between units that could be shared?
      • Who is actually watching the cable TV? Are we driving every vehicle on the GSA lease? Who is using the MiFi and why?
      • How many people are under each cost center? Have you done a cost per person analysis on things like TDY or GPC? Are there outliers? Why might that be (rank, job, special equipment, specific conferences/training)?
      • Is your unit deploying this year? If so, when? Will that cause your requirements to increase or decrease? Both scenarios are plausible, but not possible.
  • Do you know how your budget was determined? Could you explain it to the Wing Commander?
  • How are you evaluating performance? What is the benchmark?
  • Have you created a feedback loop with your managers? Periodic budget reports should generate feedback on performance variance against budgets
    • For feedback to work properly, it should be regular, expected, consistent and timely.
    • The best feedback loop is to sit down monthly with each cost center manager to review the budget-to-actual variance report.
    • Constantly incorporate changes. Budgets are living, breathing documents.
  • Find the right balance. Generic or vague estimates are worthless. But the cost benefit analysis must be reasonable. Commanders can’t know every single detail months in advance, but should be able to provide enough of an outline to “frame out” a budget.
  • Initiate Responsibility Accounting. Responsibility accounting means structuring systems and reports to highlight the accountability of specific people (cost center managers). Individuals within each organization must be empowered with both the budget and authority to execute their mission. One without the other is pointless.
  • Separate your budget into fixed versus variable costs. This greatly reduces the number of lines to review.
    • Unfortunately, fixed costs, because of their apparent static behavior, are not always reviewed regularly and critically to determine reasonableness. These are your biggest cost drivers; give them the attention they deserve each year.
    • Variable costs like GPC and travel are the areas to scrutinize most closely. Rarely does a “copy/paste” budget hold up to close scrutiny.
    • One major concern of relying upon historical budgets as a basis for future prediction is that a unit may be perpetuating past inefficiencies.
  • Relationship of Cost to Review Frequency (insert graph)

Resource Advisor Questionnaire

RPA

  • Always be able to answer the 5 W’s
    • Who – Who is going? How many PAX? What are the ranks?
    • What – What is the mission? What does it accomplish? Be able to justify
    • When – What month? How many days? Do you have the quarterly authority?
    • Where – Where are they going? Decent required? Per Diem rates? MilAir? On base?
    • Why – Is there a cheaper way to accomplish the mission, e.g. VTC? Why some many people?

O&M

  • Ask the similar 5W questions as above but put your O&M thinking cap on. Questions are slightly different, but critical thinking remains the same.
  • What are your main cashflow drivers (quarterly authority)?
    • Large contracts (IDT lodging)
    • MIPRs (utilities)
    • Civilian Pay

PowerTrack/Syncada MORDs

Commercial (Syncada, C-MORD)

Legacy – NP in 11th and 12th position in SDN.  PC Code ST. Base obligates.

DEAMS – MP in the 11th and 12th position in SDN. Planned PO. Requisition (PR) Amendment will have Purpose code “0” (zero). Original PO with Purpose code P auto obligates. Approved PR Amendments must be associated to Original PO.  Do not intermix EEIC/OCs on Transportation MORDS.

See Object Classes/EEICs below to use for the HHG/NTS

See below for the acceptable Object Classes/EEICs available

Processed via US Bank – Syncada, https://portal.syncada.com/USBank/Login.aspx

Training audio file and slides for Syncada BI Funds Manager reports is located in the Syncada folder at : https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training/

Organic (AMC/DCBS/OCONUS, G-MORD)

Legacy – MM in 11th and 12th position in SDN.   PC Code G. Base Obligates

DEAMS – MM in the 11th and 12th position in SDN. Standard PO. Base manually obligates.  Check IPROC to ensure the MORD is listed in the Order Column

Charges Processed by AMC via DCBS to DFAS, https://dcbs.transport.mil/.  Email DCBS.Helpdesk@us.af.mil for DCBS access instructions Sign up for TAC Monitor Role on your DD 2875

See below for the acceptable Object Classes/EEICs available

Preval in the 1st 6 business days of the month.   Training video for DCBS pre-val is located in the DCBS folder at :

https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training

  • OCONUS PCS Shipment, OCONUS Cargo (Freight) require both a commercial and an organic MORD
  • MTA/PAX Organic Accounting (G-MORD) must be sent to the DCBS.Helpdesk@us.af.mil.  The subject line should include MTA/PAX MORD, CAER account #, and CIC. 
  • Freight/CARGO (Commercial/Organic) cannot use the EEIC/Objects classes designated for Commercial HHG and NTS:
    • For HHG, HHG Prog Code,  HC = 46200 or 220.1101, 46203 or 220.1103, 46250 or 220.1104 , 55792 or 257.2292, 55793 or 257.2293
    • For NTS HHG Program Code,  HS = 55791 or 257.2291
    • All others OC/EEICs allowed will be coded Freight and the HHG program field should be blank
    • HHG Prog Code in TGET is the driver to the Syncada Chart of Accounts (COA) for invoicing
  • Commercial MP MORDS cannot use EEICs for Organic MM MORDs
  • Organic MM MORDS cannot use OCs that crosswalk to EEICs that begin with 462% (those are for Commercial purposes)
    • Please review OCs in the 253 category to select the best OC/EEIC  
    • MM MORDS need to be manually obligated at base level.  Please double check to be sure both the requisition and purchase order are approved
  • The Purchase Order/MORDS must be obligated for the document to flow to TGET

You must check TGET to ensure your MORD/LOA is properly loaded to TGET (this usually occurs 3-5 days after obligation):

For how to check TGET Review the audio or video files located in the DCBS or Syncada folder at: https://usaf.dps.mil/sites/10194/Knowledge_Base/Shared_Documents/DCBS_and_Syncada_Training

Misc Payments MORDS Purpose Codes

Link

Advana Notes

DAR-Q-Access-GuideDownload
Assigning Records in AdvanaDownload
DD2875 SAAR InstructionsDownload
ADVANA-Template-DD2875-LastName-FirstName-MIDownload
Advana User Admin RoleDownload
DARQ-Validations-What-RA-Tester-Comments-are-NeededDownload
AppendicesDownload
Temporary-Duty-Assignment-KSD-Package-ExampleDownload
Examples-of-Key-Supporting-Documentation-Advana-DAR-QDownload

KSD Checklist of acceptable documentation

Favorite DEAMS Videos

Still Need to Watch

G-Invoice

Government Invoicing  –  A web-based application that efficiently manages government invoicing from the initial general terms and conditions (GT&C) all the way through Intra-Government Payment and Collection (IPAC) notification for reimbursable work between two federal agencies (AF to Army, AF to DLA, AF to GSA, etc.) 

  • Department of Treasury system
  • Centralized repository for agreements
  • Automated handshake and agreement between buyer and seller

AFAFO G-Invoicing Team:

My Favorite Power BI Resources

These are just a few of my favorite resources I’ve run across in my Power BI journey.

My #1 suggestion is to buy the books and work through the examples. Don’t just read the book; actually go through each example. Yes, it’s an insane amount of work, but it’s the best way to truly learn.

I’ve listed the books in the order that I recommend reading them. The first books provide a solid foundation and the latter books hone your DAX and Power Query skills.

Books

Websites

YouTube