Great video by Josh Johnson on how to analyze the STH within DEAMS via Power BI.
https://www.milsuite.mil/book/leadercasts/10835

Great video by Josh Johnson on how to analyze the STH within DEAMS via Power BI.
https://www.milsuite.mil/book/leadercasts/10835

UPDATE Several of the links below are broken, but you can still search FICS for the product via their new product search page.
Find these and more on the Financial Information Collaboration Space (FICS)
Final Push Day is 27 Sep 2021
DFAS command post begins 13 Sep 2021
The Tool Suite provides a number of tools that can be used to manage DODAACs.
The Department Of Defense Activity Address Code (DODAAC) is a six position code that uniquely identifies a unit, activity, or organization that has the authority to requisition and / or receive materiel. Using the DODAAC Management system, you will be able to request a new DODAAC, change and existing DODAAC, or delete a cancelled DODAAC. The system also provides the ability to complete the annual validation of all Air Force DODAACs through an automated system.
FY DoDAACS ‐ Require that the requestor furnish the FB/FE/FG DoDAAC that will provide accountability for the FY DoDAAC being requested IAW AFMAN 23‐230 Table 2.1. Additionally, requester needs to provide the process that will be used for processing receipt transactions/accountability and a POC for the receiving locations on the ground at of the TAC1/TAC2 addresses. The FY DoDAAC is to be used in the supplementary address field of requisitions (positions 45‐50) from the accountable DoDAAC.
https://dodaac.wpafb.af.mil/about.aspx
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:
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)
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.
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.
AFAOC Data Analytics & Field Support
Download CBA Reconciliation Template
SAF-FMFC-AFAFO-A-CBA-Rolling-Balance-Memo-17-Mar-2020 blank-cba-formWhen 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.
DFAS Limestone | JAMBA
Comm 207-328-1632 / DSN 220-1632
New Resource updated August 2025: CET-FM Certification Training
Review the slides below for CET requirements and guidance
Remember, you cannot retake/use a course for CETs you used to achieve FM Certification.
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:
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-AlertsWe 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.
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.
Michael Smiley, GS-15
Director, Air Force Accounting and Finance Office – Accounting
SAF/FMFC
SAF-FMFC-AFAFO-GPC-Certifying-Officer-Appointment-3-19-2020Worldwide 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.
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.
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):
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.
Provides full AFNet resources via government-furnished and configured devices. There are now two primary ways for active duty AFNet users to access VPN
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.
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)
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:
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.
KATHRYN A. MERCER, Col, USAF
65F Career Field Manager (USAF Reserve)
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!
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.