Power BI ADOS Planning Tool Training

In this video, our team discusses conducts a training session on the new ADOS Planning tool. The tool utilizes Excel and Power BI to visualize three important data points our Wing Commander needs to drive decision making:

  • Historical – Because of the way PBAS now obligates orders and allocates quarterly funding into the future, our leadership needs to know the who, what, when of each Group’s budget. This is the easiest part since it’s a simple pull from the accounting system.
  • Planned – What is the plan for your remaining budget? Before you go to the boss, he wants to see how the Group’s plans on allocating the remainder of their budget.
  • Unfunded Requirements – Provide the who, what, when on the people Group can’t afford (UFRs).

I’m really excited about this tool and our new ability to visualize the Wing’s ADOS budget in one timeline.

MilTube-ADOS Planning Tool Training (CAC Required)

301FW Power BI Finance App (CAC Required)

301FW SharePoint RPA Budget (CAC Required)

CBA Delinquency Report and Reconciliation Template

As you may be aware, SAF/FM AFAFO-Banking is responsible for the Enterprise Centrally Billed Account (CBA) Card Program Management (HL2 with DTMO and Citibank), SAF/FM AFAFO-A is responsible for Air Force Accounting Policy and SAF/FM AFAOC (HL2 with Citibank) is responsible for Oversight of the CBA card delinquencies and exception requests. 

The CBA payment process is very time sensitive.  As such, the SAF/FM AFAOC provides a weekly delinquency report to leadership and sends out notices individual to cardholders whose accounts in danger of suspension with a suspense date to clear the unpaid balance. The goal is actively work with delinquent  cardholders to ensure the full card balance is paid, and to ensure timely and accurate payments are sent to the payment disbursing office to avoid suspension.   

We would like your additional leadership support with clearing the delinquency report ensuring the CBA credit cards are paid. Our office would also like your assistance in coordinating/forwarding to our partnering MAJCOM/COCOM A4 POCs for assistance.  Please include the SAF/FM AFAOC in any forwarding action. 

In recent months, CBA cardholders have asked why after their card statement is paid each month, there is still an unpaid balance on their card.  In most cases, this is due to a rolling balance where a charge was  unaccounted for on previous statements, or there was a payment error at the disbursing station. For unaccounted charges, this could be one charge on one statement or many charges over several statements. As such, a cardholder’s account reconciliation is needed to determine where the un-reconciled charge(s). This is not a tasking or inspection to reconcile ALL the CBA cards, but accounts that appear on the delinquency report should complete a reconciliation to ensure they don’t have a rolling balance.

Although there is still a requirement to maintain supporting documentation, during this specific reconciliation process, there are times when the supporting documentation may not be available due to various circumstances beyond anyone’s control.  In the past, that  prevented certain charges from being paid and the account not fully reconciled, causing rolling balances contributing to account delinquencies and possible card suspensions.  As a remedy to these continuous delinquencies, we are pleased to provide these tools to assist in the reconciliation process and possible payment of those charges. 

1) The memo below outlines the process to assist with long standing (rolling balances) for Centrally Billed Accounts (CBA) when documentation is missing or destroyed.  The memo applies to Traditional, Unit, MEPs and Special Program Cards for both DEAMS and Legacy Systems covered under the Air Force CBA program

 A lost or destroyed record could be any required supporting documentation to include receipts or orders. The records custodian is usually the cardholder as they are required to keep supporting documentation for their charges.  Additionally all  card activity is subject to inspection by SAF/FM AFAFO – Banking. A reconciliation can be part of an official inspection.  Again, this is not a tasking or inspection to reconcile ALL the CBA cards, but accounts that appear on the delinquency report should complete a reconciliation to ensure they don’t have a rolling balance.

  • In addition the memo, if the reconciliation issue is in prior fiscal year and cardholder still has the records….the best practice will be for the reconciler to send a similar package to the comptroller prior to sending the supplemental payment package to the disbursing office to ensure funding is still available for that year. 
  • Dormant obligations are de-obligated if they are thought to be complete.  Financial Managers may have received confirmation in the past this was complete only to find in the reconciliation it was not complete.  In those cases, if the obligation was de-obligated, an upward obligation adjustment package may need to be completed by  comptroller office personnel depending on funds available at that location. 

2) The attached CBA Recon Template (MS Excel Spreadsheet) will assist in researching and reconciling the account to determine the rolling balance over time (whether it is a consistent balance year after year or if there are multiple charges over multiple invoices contributing to this residual/rolling balance).  The next steps in reducing delinquencies are to effectively meet the requirements and controls for timely and accurate packages to the payment disbursing office, and improve payment times at the payment disbursing offices.  Your assistance with this effort is greatly appreciated as there is a renewed focus on prompt payment interest amounts.

Also attached is the weekly CBA Delinquency report. Our office provides this report report in hopes each responsible party will assist in clearing the over due balances.   As mentioned above, the payment process is very time sensitive. When the required cut offs are not met; it can greatly impact the card’s availability status.  As such, the first tab of the report is a dashboard tab reporting metrics including the total number of cards per MAJCOM that are in delinquent status, which bases with traditional cards didn’t accept their invoice within the 5 day limit, which base didn’t sent their payment request to DFAS within 10 days, which traditional invoices sent to DFAS still have pending requests for information, and which invoices were not assigned to a DFAS technician within 5 days of receipt from the base.  Also included is a trend line of delinquent card totals.

Within the data itself are highlighted columns for the account number, card type, account delinquency status, number of days past due. These will be valuable in assisting in the research of payments.  In some cases, payment requests have been prepared and sent to the payment disbursing office. Our office doesn’t have record of payments sent to DFAS or Combined Services Center when the PO field is blank. 

Our office is available if you have any further questions or need assistance with the use of the tools provided.  Thank you in advance for anticipated cooperation as we work together with our partners to move the mission forward.

Source:

Spencer Whitcraft

AFAOC Data Analytics & Field Support

Resources:

Download CBA Reconciliation Template

SAF-FMFC-AFAFO-A-CBA-Rolling-Balance-Memo-17-Mar-2020

blank-cba-form

Proper DEAMS Purchase Order Type for Syncada MORDs

When establishing Purchase Orders (POs) in DEAMS for US Bank Syncada invoices the correct PO Type is Planned Purchase Order

Recently there has been an increase of MORDs being established with a PO Type of Standard Purchase Order, which is causing a lot of manual work.  This causes the invoice to Interface into DIMES with an error. It will then need to be uploaded into EDM and manually processed by straight post (similar to a straight obligation) since releases cannot be reserved, approved, or matched on Standard POs in DEAMS. This causes delays in processing.

There are job aids on the DEAMS Outreach Portal or they can reach out to their DEAMS SME for technical assistance.

Source:

Jacquelyne Morrow

DFAS Limestone | JAMBA

Comm 207-328-1632 / DSN 220-1632

Step-by-Step Directions for Recording CETS in LMS

With COVID-19 keeping many of us home, now is the perfect time to get caught up on your FM Certification CETs.

Review the slides below for CET requirements and guidance

  • Training hours required by Cert Level (slide 5)
  • When CET Cycle Starts and Ends (slide 6-8)
  • What Counts for CETs (slide 9-13)
  • What Does Not Count for CETs (slide 14)

Remember, you cannot retake/use a course for CETs you used to achieve FM Certification.

Step-by-step instructions to record CET’s in LMS

Got to FM Online

  • Click on the FM LMS tab
  • Click on LMS Login (use your E-mail certificate)

Instructions to Record Learning for CET’s

  1. Search keywords FM CET Course
  2. Select the correct CET Cycle (Years 0-2 if this is your 1st CET cycle or Years 2-4, if it’s your 2nd, etc)
  3. Select Course 01 for the first class you are recording (repeat this steps 3-7 as many times as needed to record your 40 hours – use Course 02, 03, 04 for each consecutive course you need to record)
    • If you want the courses to display in date order, you will need to enter your oldest course first (Course 01), and so on
  4. Change Completion Status to Seminar Complete…
  5. Change the Completion Date to actual date you completed the class
  6. Change the Credit Hours to the number of hours you received for CETs for the class
  7. Enter Course Name in the Comments field
  8. There are NO ATTACHMENTS for CETs
    • Retain training documentation for a minimum of 4 years, in case of an audit
  9. You MUST Record Learning one more time; Keyword Requirements Complete
    • Choose the correct CET cycle; Year 0-2 or Year 2-4
    • Change Completion Status to FM-Achievement-Complete…
    • Note: CET’s are self-certified – no supervisor approval required
  10. Pull a copy of your CET scorecard, ensure it states All Requirements Met, and keep a copy with ALL completion certificate used as CETs
    • Retain for copies for a minimum of 4 years, in case of an audit

Other Important Items to Note

  • Just as FM Certification is a job requirement for all in FM-coded positions, CET’s are a job requirement for all FMers and follow the same failure to comply guidance
  • You may only use training completed after your certification date and within your training window for CET’s; idea is to maintain training in the FM Competencies
    • Example: Certified 7 Sep 2017
      • CET training window for 0-2 Year Period:  8 Sep 2017 – 31 Dec 2019; required hours must be completed in this window
      • CET training window for 2-4 Year Period:  1 Jan 2020 – 31 Dec 2021; required hours must be completed in this window
      • Remember:  Wait for the next CET window to open before completing additional training or you will not be able to use it
  • CET completion is Self-Certified; meaning there is no supervisor approval step, once your scorecard states All Requirements Met, you are finished for that CET window
  • FM Cert Level 1 = Proficiency Level 1 = 40 hrs CETs
  • FM Cert Level 2 = Proficiency Level 3 = 60 hrs CETs
  • FM Cert Level 3 = Proficiency Level 5 = 80 hrs CETs

Helpful suggestion: Use your CET training time to prepare for your next FM Cert level. If you are currently in a Level 1 position, take Level 2 courses for your CETs. If you are currently in a Level 2 position, take Level 3 courses for your CETs. When you get that next promotion, this will help ease some of the stress of being in a new position and save you some time as well.

Housekeeping: Supervisors, this is a good time to look at LMS to verify each of your Employees Scorecard information is correct:

  • Verify Employee’s Component Organization
  • Verify Employee’s Supervisor (if you cannot see them, their Supervisor is not correct in LMS)
  • Verify Employee’s FM Cert Level
  • Verify Employee’s Due Date
  • Verify Employee’s Job Series
FM-Certification-CET-Training-DCS-Training-v1019

DoD-FM-Certification-CET-Info

How to Setup SharePoint Alerts

I recommend setting alerts on all the SharePoint sites you frequent. I subscribe to numerous sites and automatically get updates in my email when sites add documents or make changes.

These alerts are great for getting updates from DEAMS, AFAFO and other sites with frequent changes. The AFAOC put together this guide for the DEAMS site, but the functionality is the same for all SharePoint sites.

How-to-Set-SharePoint-Alerts

Centrally Billed Account Quick Reference Guide

We were asked to share with the widest dissemination within the CBA community. Please see the information below and direct your account set up questions to Mr. Harraway or Mr. Anthony.

Below are some common issues that are occurring and questioned per AFAFO. Please use the Quick Reference Guide to help with managing the account in Citi Manager. This information will be posted on the GTCC SharePoint.

Set Passcode and Online Process

  • No one should be setting passcode or doing online, because of the issues with Citi and the need to ensure everyone is properly trained.
  • Approximately 50 applications are in the system that are filled out incorrectly and will reject at Citi.
  • These applications were deleted on 3/11/2020, and will need to be reaccomplished once given the green light to start using the online application process.
  • If you need to submit an application, you will need to do a paper form and fax the application to Citi.  If you are experiencing an issue with faxing, you can send the application to Darrell Haraway.

Hierarchy Pull Transfer

  • There is a known issue with this feature and has been reported to Citi.  This should be fix by midnight on 3/12/2020
  • If you need to transfer an account in to your hierarchy, you will need to call Citi at 1-866-670-6462 for HL4-7 APCs, HL3s call our dedicated line.

Create New Application via Manage Card Account

  • This feature is not for DoD and is not available to us. The DoD application process will be initiated by the cardholder. But this is on hold

Quick Reference Guide

  • Attached is an updated version, now this is mainly to help with navigating in CitiManager and not intended to replace the Citi training manuals.  

Training

  • Individuals should signup for training via CitiManager – Learning Center –What’s New
CBA-Quick-Reference-Guide

GPC Certifying Officer Appointment Guidance from AFAFO

We know when the new SmartPay 3 contract came on board, there was some confusion on what responsibilities were AQ and what were FM. FM is responsible for appointing the certifying officer; hope this memo clears things up going forward. Instructions to appoint certifying officers in the system are attached in the memo.

Below are additional instructions for getting your appointing authority access to the system to appoint certifying officers:

  • If you are brand-new to PIEE, you must register to create your account.
    • Using Internet Explorer, go to https://wawf.eb.mil, sign the Consent Statement, and select the “Register” button to start the process.
    • Register with your CAC as a Government – DoD user, following the system prompts. See the previous slide for FAQs relating to DoDAACs.
    • Select “JAM – Joint Appointment Module” from the Application list, and select “DD577 Appointing Authority (DD577-AA)” from the Roles list. Click “Add Roles.”
    • Click “Group Lookup” to find and select your Group.
    • Enter your justification and follow the system prompts to complete your registration.
  • When you have completed the registration, your Supervisor will receive a system-generated email to approve your request.
  • After your supervisor has approved your registration request, an approval notification will be sent to your Component’s Group Administrator (GAM).
  • You are now ready to use PIEE

Source:

Michael Smiley, GS-15

Director, Air Force Accounting and Finance Office – Accounting

SAF/FMFC

SAF-FMFC-AFAFO-GPC-Certifying-Officer-Appointment-3-19-2020

Help with Air Force Telework IT Issues

Worldwide operations require AFNet remote network access capability. AFNet enterprise forces are engaged to expedite additional remote access capabilities, inform AFNet users of capabilities, and assure access to available capabilities. The Enterprise User Remote Access Modernization (EURAM) VPN client was deployed to AFNet laptops and laptop-like devices on 11 Mar 2020 in accordance with MTO 2020-071-005, EURAM AFNet Deployment, expanding remote VPN capacity by 60,000 concurrent connections.

Below is a listing of current remote access capabilities. As many of the below are shared resources, users are asked to select the one that best fits mission essential functions and disconnect when not required.

Primary option for users needing only email access. Requires AFNet account, CAC reader, personal or government computer.

Outlook Web Access (OWA)

  • Internal to AFNet:
    • Open browser (Edge/Chrome), go to site: https//webmail.apps.mil/
    • Select the email certificate to access your email via the internet
  • External to AFNet:
    • Open browser (Edge/Chrome), go to site: https//owa.us.af.mil/ External to AFNet:
    • Select the email certificate to access your email via the internet

Notes: 1) S/MIME software is required to open encrypted email in OWA for both home and work computers. This was previously pushed to AFNet devices for Edge/Chrome, and requires manual installation for personal devices.  Of note, there is not an S/MIME solution for Chrome home use. 2) For additional information see SMIME Instructions in resources section below, NOTAM 2019-255-001 and MTO 2019-350-001.

Blackberry Unified Endpoint Management (BUEM) Devices

The following AFNet resources are available via government furnished, BUEM-enabled devices (phones and tablets). BUEM applications offer many capabilities and features that provide access to AFNet resources and enhance productivity for Air Force mobile device users. The following resources are available to BUEM-enabled devices (phones and tablets) that are updated to the mandated iOS version (iOS 13.2):

  • Blackberry Work – AFNet email, contacts, and calendar along with the ability to sign and encrypt messages
  • Smart Office for Blackberry – Viewing and editing documents and files, include the digital signing of configured PDF documents
  • Blackberry Access Secure Web Browsing – Access to CAC-enabled websites (DTS, AFPC Secure, AF Portal, MyPay, etc)
  • Blackberry Tasks and Blackberry Notes – Allows users to create, edit, and manage tasks and notes that sync with their Microsoft Outlook 365/Outlook Tasks
  • OneDrive and SharePoint Online – Access to these capabilities can normally be configured through Blackberry Work but are currently unavailable. A full restoral is estimated 23 Mar 20

Notes: 1) BUEM users received a direct email on 12 Mar 20 advertising capabilities available. 2) Some BUEM applications referenced above may require the user to download through the Work application and should automatically configure. 3) For additional information see Blackberry UEM Instructions and How to Guides in the resources section below, NOTAM 2019-268-005 and NOTAM 2020-041-001.

Virtual Private Network (VPN)

Provides full AFNet resources via government-furnished and configured devices. There are now two primary ways for active duty AFNet users to access VPN

Threat Management Gateway (TMG) (legacy): AFNet SSL VPN Client

  • Assure laptop is configured to support wireless connectivity
  • Establish a functional internet connection (wireless or wired) outside the AFNet
  • Open ‘AFNet VPN Client’ or ‘AFNet SSL VPN Client’
  • Click ‘Connect’ to establish VPN connection
  • If migrated, utilize the “Authentication Cert” (16-digit PIV-Auth certificate) from more choices, if not, continue to use 10-digit “ID Cert” to gain access

EURAM VPN (new): New EURAM VPN capability deployed to AFNet laptops and laptop-like devices on 11 Mar 20.

  • Assure laptop is configured to support wireless connectivity
  • Establish a functional internet connection (wireless or wired) outside the AFNet
  • Double click on the USAF VPN Client icon on the desktop or by selecting BIG-IP Edge Client through the Start Menu
  • Click the “Connect” button – the client will attempt to start a VPN connection
  • The client will display a DoD monitored resource message. Click ‘Okay, Proceed to App” green button to proceed  
  • Select the “Authentication Cert” (PIV-Auth) certificate from more choices. Note: Some users who have not migrated may still have to select the 10-digit “ID Cert”\ After VPN session is established, VPN will minimize to the system tray
  • After VPN session is established, VPN will minimize to the system tray
  • To Disconnect, open the client and select “Disconnect”

Notes: 1) EURAM VPN connectivity will be disconnected after 2 hrs of inactivity, or when the computer goes to sleep—whichever occurs first. 2) EURAM VPN client is not currently deployed to ANG. 3) EURAM capability fielding was expedited; planning and fielding for full capacity continues.  4)  Any concerns with client deployment or user access should be reported against Master Remedy Ticket #25594076–The Most common error is inability to access networked shared drives. 5) For additional information see EURAM User Guide and MTO in the resources section below.

Key Reminders:

  • Air National Guard (ANG) and Air Force Reserve users should contact local resourcing for additional information on VPN and Desktop Anywhere resource capabilities and requirements
  • OWA is a recommended first option if email is the primary requirement
  • If not actively working, log off VPN to allow other users to access the AFNET VPN
  • Ensure government laptops have wireless functions enabled, wireless settings checked, and correct power cord before users depart their normal duty location

Resources:

MTOs and NOTAMs are in the AFIN Compliance Tracker, https://act.af.mil/ACTv2 (SIPR), or ESD Portal, https://esd.us.af.mil (NIPR)

MTO 2020-071-005, EURAM AFNet Deployment

MTO 2019-350-001, Google Chrome S-MIME Deployment

NOTAM 2020-041-001, New Features Now Available on BUEM Connected Mobile Devices

NOTAM 2019-268-005, Blackberry UEM New Features

NOTAM 2019-255-001, OWA Encrypted and Digitally Signed Email Capability (S-MIME)

AFRC Announces FY20 Reserve FM Readiness Forum Dates and Location

The Air Force Reserve Financial Management Readiness Forum will be held in Tampa, FL on 22-23 Aug with the travel day on 21 Aug. We highly encourage all FM TRs, IMAs, AGRs and ARTs to attend the two full days of education, professional development, and information on reserve readiness.
 
Here are the details you need to know:

The forum will take place at the Marriott. Rooms should be booked no later than 10 Aug here.

The Marriott offers a shuttle to and from the airport so you will not need a rental car. A hotel shuttle is also available to take you to and from local eating establishments.  
 
Our schedule will begin at 0800 and end at approximately 1600. If you need to depart on 23 Aug do not schedule flights before 1800.  The agenda is still being finalized but the main areas of emphasis will be:

  • What is going on in the career field, deployment and training updates (FMXX)
  • Best practices,
  • Travel updates
  • Mentoring
  • Officer and enlisted calls
  • Financial reserve working group update
  • Deployment stories
  • DoD FM Certification

One social event is planned for our group. There will be a social hour the evening of 22 Aug in hotel (time TBD). Signs will be posted.

Our special guests are still being finalized and that list will be sent out in future communications.

Uniform of the day will be ABUs or OCPs.

Man-days are unit funded (Annual Tour, RPA or MPA) 
 
If you have questions/concerns or special needs please let Lt Col Todd Main or MSgt Teresa Saunders know.

Source:

KATHRYN A. MERCER, Col, USAF

65F Career Field Manager (USAF Reserve)

Power Query M Code – GTC Delinquency Report

One of my goals with Budget Dust is to create a community of data junkies. A group that uploads new ideas and improves each other’s code and documentation. GitHub is a code hosting platform that makes version control and collaboration easier. It lets you and others work together on projects from anywhere. Read this short tutorial on what branches are and how to publish commits. Don’t worry if those words don’t mean anything to you, it’s easy to pickup with a little practice.

The M Code below enables FMers to quickly transform, raw unedited data inside Power Query in a consistent, reliable process. Simply copy/paste the code into the Advanced Editor in the Power Query Editor in either Excel or Power BI. Then simply insert your local file path at line #2 where it says “INSERT_YOUR_FILEPATH_HERE” and then run the code. Voilà, it works!

Crucial rules to adhere to when using other people’s M Code:

  • Change the file path to your local machine or share drive
  • In most cases, make sure the file name does not change day-to-day
  • Download the file exactly the same way as the original code author intended

In future posts and YouTube videos, I will demonstrate step-by-step how to both implement the code and edit/improve the code on GitHub. As a community, let’s refine, improve and standardize our processes. In turn, we can create consistent reliable code used across the Air Force.

GitHub Repository:

https://github.com/budgetdust/GTC_DelinquencyReport