Alex: So good morning everyone.
This is Alex Absara with Fiscal Service.
And today, I know it's kind of been an ongoing topic for us,
but it's about reporting functionality
that we have in GTAS and G-Invoicing.
And this might be something that you've heard about.
We tried to present this during last calendar year,
I think in the fall during third quarter scorecard meeting
to really get the topic out there,
make sure everyone's aware about the functionality,
but really what's coming up here in quarter two
for fiscal year '23 and the scorecards
is there's gonna be a new metric presented
around G-Invoicing
and how basically monitoring agency progress
with the mandate that was effective as of 10/1/2022
for new orders.
So with that, with that being on the scorecard,
we had to figure out a way, here at Fiscal Service,
to really monitor compliance
the progress agencies were making
with their G-invoicing reporting.
I'm getting a little feedback there.
But really had to figure out a way to monitor that.
Robert: Give me a moment, Alex.
I'm gonna just, as a warning for everyone,
I'm gonna mute all.
So if you're dialed in by phone,
you're gonna have to hit star six to come off mute.
That includes you, Alex.
Okay, muted all the lines now.
And then if anyone does wanna come off mute to engage,
feel free to do so.
You also have the option
to enter your questions in the chat.
So sorry Alex, back to you.
Alex: All right, thanks Robert.
Thanks for doing that.
Definitely makes it easier without the feedback.
So when I was talking previously,
we were basically saying we had to figure out
a way to monitor the progress
and compliance with the mandate.
And what we really set up was we figured out
or created a way to interface G-invoicing information
into GTAS for nine data points.
And within GTAS, we created nine proposed analytical edits
to compare what was being reported
with transactional activity in G-invoicing
compared to what was being reported
on your just trial balance block file in GTAS.
So when we're comparing that information,
we can really see the overall reporting
that was happening in GTAS
compared to what was happening in G-Invoicing
and really put a percentage behind that
to see the overall compliance
and progress agencies were making.
So one thing we heard when we started talking
about putting out this metric on the scorecard
was agencies wanted a way to really dive in the details
and reconcile the data between the two systems.
So what we did, and you're gonna hear more about
from Jeff Board and Justin Sheline is how, I guess,
there's different reporting functionality
in both systems that you can use in unison
to really reconcile any differences that you have
and discrepancies you have
between the two systems to do that.
So really we're gonna dive into the details
of what reporting capability we have in G-Invoicing
and then what we're gonna have in GTAS
to basically wrap all that data up
and reconcile and really improve your metric
that you have on the scorecard.
But like I mentioned,
this is gonna be a new metric as of Q2.
So coming up for this period,
period six reporting in GTAS.
And when we do scorecards coming up in May,
this will be on the scorecard and as Jeff
and Justin walked through this,
it'll really help you out on how you can improve
the overall percentage rating we have
on the scorecard as well.
So I'm going to take a brief pause,
see if there's any questions about that
before I kick it over to Jeff Board
to talk about the G-Invoicing functionality.
Angela: Hi there, my name's Angela Wilson, I'm with NRC.
Thank you so much for doing this for us.
You spoke very quickly and I am trying to take some notes.
I know this is gonna be recorded for us to go back,
but if you could go just a tad bit slower,
that would be great.
Alex: Okay, is there any certain points you missed,
Angela, that I could repeat or?
Angela: No, no, I'm good for now.
Just the pace was a little quick, thank you.
Alex: I apologize about that.
But yeah, if there's any other questions,
feel free to speak up or if not,
I'll kick it over to Jeff to jump
into the G-Invoicing piece.
Jose: Hey, good morning, this is Jose with BOP.
I have one quick question regarding this reconciliation
between G-Invoicing to GTAS.
So I'm guessing that the G-Invoicing system
is gonna talk back to Treasury within GTAS
and it's gonna check for some edits.
Are we expecting those edits to be analytical
or fatal by Q2?
Alex: So they're definitely
gonna be proposing analytical,
and that's definitely a good question,
it's something that we've been asked in the past,
but they're gonna be proposing analytical
for the foreseeable future.
We're not planning to take those fatal anytime soon
probably until we have most activity in G-Invoicing
and we're getting to a place where we feel comfortable
with with making it fatal.
But we'll definitely communicate that out
to all federal agencies
before we get close to taking that fatal.
But really it's a proposed analytical edit.
We're gonna be using it as like, as I mentioned,
as a metric on the scorecard,
but it'll definitely be proposed analytical
and not cause you not to be able to certify
your treasury account symbol in GTAS.
Jose: Okay, thank you.
Alex: You're welcome.
All right, any other questions before Jeff takes over?
Hi Jeff.
Jeff: All right, thank you Alex.
Good morning everyone.
This is Jeff Board from Fiscal Service.
So I'm gonna do a quick little demo this morning,
give you guys sort of a visual of the report
that we have in G-Invoicing,
kind of give you a look of how you can navigate to find that
and then we'll walk through the data that's contained
in that report and how that you'll be able to use that
to try to reconcile your differences.
So to start off the report
that we've developed in G-Invoicing,
it's called the ATB summary report,
and it's gonna allow you to run reports
by the accounting period in the TAS
to identify which orders are associated
with your IGT by cell differences.
So this report's gonna provide agencies with information
that is needed to go into the application,
query up the orders or the 7600EZ invoices in G-Invoicing,
just to kind of fully understand
which performance transactions
are involved in those differences.
So this report became available with our 4.6 release
and I did wanna mention that
in order to access this report,
the agency user must be assigned
the TAS reconciler role in G-Invoicing.
So if you don't have that TAS reconciler role,
you'll wanna work within your agency
to make sure you get that access
to be able to query this report.
So moving over to G-Invoicing,
I'll just quickly show how we navigate to find this report.
So in the dropdown, once you log in to G-Invoicing,
you wanna make sure you're in the correct account,
and then under the reports dropdown,
you'll click there, and it'll list out the various reports
that you have access to run.
And like I said,
if you don't have that TAS reconciler role,
this ATV summary report's not gonna show up
in your dropdown.
So that's gonna be, you're kind of sign to know
that you need to reach out to get that access
if you don't see it present in that dropdown.
Once you click ATB summary report,
you're only gonna have two data fields to fill out.
So you'll click the accounting period.
Just for demonstration purposes, we'll pick March,
and then over here you'll plug in
your treasury account symbol.
So like I said earlier,
you can only run this report
by one accounting period and one TAS.
And it does have the type ahead feature.
So if you want to start typing in
like 020 for treasury and the ID,
you can more easily locate the TAS involved.
And once you select one,
you'll just click this run report
and it'll result something that looks similar to this.
So I wanna just pause,
make sure this is showing up big enough
for everybody to see.
If not, just let me know.
All right, so I just wanted to quickly walk down
through the report and show you the information
that's gonna be contained here.
So as I mentioned earlier, the parameters here,
it'll call out the accounting period
and the TAS that you've run the report for.
And if you need to research more than one TAS
or a TAS that is involved
in more than one accounting period,
you'll have to run multiple reports.
As far as the data, I'll just kind of walk across the screen
and kinda explain to you what information
we've got captured here.
So the first column there, the buy-sell indicator,
that's as it relates to the TAS.
So if you see an R,
that represents the requesting agency TAS,
if you see an S, that's servicing agency TAS,
and that's there in column A.
The reciprocal category is captured in column B,
so it'll either be 22, 23, or 24,
which represents that buy-sell reciprocal category.
The GTAS financial statement lines are included in column C,
so that's how you'll see it on the financial statement line.
The sub-element information,
we have that captured in column D,
it categorizes the performance that's involved.
So you will see either a deferred, unreceived,
unsettled, performance, delivered, or easy invoiced.
And we have all of those explained
in more detail down here under the legend.
So I won't really dive into each one of those,
but we do have a legend down at the bottom
that will help you guys understand a little bit
more of what's going on up here.
Noah: Can I take a step back?
It looks like what,
and this is Noah Calvin from the State Department,
-: Sure. -: So I see this seems
to be from when I see this report, couple items.
It might be beneficial for any
to have a lot of different TAS, to just have it across.
I've seen other systems
where you have to drill down by a TAS,
that creates a lot more work.
It would be better if there's a global report
that would cover everything just to consider.
The second item is I see this report
and I'm just kind of wondering is there a way
to see what's in GTAS and not in G-Invoicing
or it's only one way where it could see a transaction
that is not in G-Invoicing at all
or is this only it has to be in G-Invoicing?
Just my understanding was just was supposed
to reconcile G-Invoicing to GTAS.
-: Yes, so -: So no.
Jeff: Good questions there.
Oh, go ahead Alex if you wanna take that.
Alex: I can jump in a little bit and help Jeff on that.
So Noah, I know your question as far
as what's in G-Invoicing what's in GTAS.
So when we get further into into this presentation
and talking about the G-Invoicing
and GTAS comparison report,
really on that report it can be more holistic
where you can run it by FR entity in that system,
it's gonna be a more summary level view.
But what Jeff's showing you here
is more the diving in the details of what you're gonna see
in that G-Invoicing and GTAS comparison report.
But I think what your question really led to
was I think the G-Invoicing and GTAS comparison report's
gonna show you you all the data,
you can see both on in that report
what's in G-Invoicing and what's in GTAS
and really dive into those details.
But if you really need to drill down more
on the G-Invoicing information
and drill into a specific TAS,
that's what these G-Invoicing reports are for
to show you what's feeding those specific data points.
Noah: Thank you.
Alex: You're welcome.
Jeff: Yep, thanks Alex.
All right, so we'll finish going
across the rows here or the columns here.
So we left off with the sub-element information in column D.
And like I said, we have a little bit more information
about each of those listed down here
under the legend section.
We've got the trading partner, AID in Maine,
listed in columns E and F.
The amount that's in G-Invoicing
will be captured in column G.
The order number or the easy number involved
will be located in column H.
So this report does capture all of the 7,600 easy invoices
as well as the orders, all in this single report.
The trading partner agency group.
The trading partners agency and group names
for both sides, requesting and servicing agencies,
are listed over here in columns I through L.
So that way, you know, just both sides of the equation.
Who's involved in the information here?
So a few things of note with this report,
like I said earlier,
agencies are only able to query one accounting period
and one TAS per report.
And we kind of have that shown in that parameters line.
And I guess the reason behind
allowing only allowing one accounting period in a TAS,
like Alex said, there's really an effort
to really fine tune in on the TAS.
We just had some concerns about the amount of data,
the large volume of data that could be returned
if we were to allow multiples to be pulled.
So for now we're just gonna leave this
as a single accounting period in a single TAS.
So this report is really just kind of designated
or designed to use for really drilling
into one TAS at a time.
Robert: Hey Jeff?
Jeff: Yes.
Robert: Before we move on, we have a couple of hands up
that I did want to call on.
So we have Felicia Forward Jones from GSA first.
Felicia: Good morning.
So when you say that it's limited to one TAS,
that's whoever's pulling the report,
'cause I see multiple TASes within the report itself.
And how does this handle, for example, let's say,
it's a big seller that's pulling this report
and there are, you know, maybe millions of lines
by TAS and document number,
does it then roll over to another tab?
Jeff: No, that's great question,
and I was just about to get to,
so the note kind of with this is that agencies
can only see the TASes that are associated with the groups
that the TAS reconciler user has access to view.
So the user that logs in as the TAS reconciler
is only gonna pull data for the TAS
and accounting period that they have access to view.
So it's not gonna pull everything,
it's only gonna be kind of in that narrow window
that they have the ability to view.
I dunno if that helps
or if you have additional like questions.
Felicia: So is it possible to test this
maybe with a user that has a system that may have,
you know, thousands upon thousands of rows?
Has it been tested in that way?
You're expecting it to be at a lower level
that this reconciliation happens?
Alex: So Felicia, I think from our perspective
in working with FRB, St Louis,
I'm not aware of any performance issues
as far as like a maximum capacity
for a specific accounting period,
as far as millions of transactions for one specific TAS.
I think we've tried looking at some of the,
especially GSA, I know there's been a seller
has some of those business lines
has huge volumes of activity and we are aware of that
and I'm not aware of any performance issues
from that standpoint.
But as far as the access goes, as far as what Jeff mentioned
and having the correct access
as you're granting access to that TAS reconciler role
and if it's someone that needs a wide range of access
for all the TAS within a certain agency,
I just make sure that they have the correct access
to be able to pull the reports
that are needed to do the reconciliation.
Felicia: Thank you.
Alex: You're welcome.
Emily: This is Emily from FRB
and the person just speaking mentioned
that they see multiple TASes.
What Jeff is trying to say, you pull by a single TAS
and if you look up their online five,
that shows the parameter.
So that's the accounting period
and then the exact TAS that was pulled.
So the multiple TASes that you're seeing
are the trading partner TASes.
So that TAS could have been traded
on the other side, the trading partner side,
with, you know, hundreds of TAS.
I have, I've done a lot of testing on this,
our cap is gonna be what the cap is,
and now I can't remember what it is, for Excel.
Like Excel will only let pull so many.
And at this point, I don't have enough performance to hit,
I haven't hit over the cap, let's just say that.
And it pulls relatively quickly.
I can't give you the exact timing,
but I have done some performance
and I've not found any problems with this.
And that's pretty, like to your concern,
is why we limit it to be able
that it has to be the specific TAS,
it's not just like pulling by AID,
because then it really should filter down a lot more.
Like instead of us saying,
"Okay, you can pull by 010 for the AID."
So that's some of, we did put some thought
into not killing anyone's systems
with pulling too much data.
So that's kind of, I just wanted to clarify
like that's why you're seeing multiple TASes
is because you're seeing the partner TAS,
but he really is only pulling by one specific TAS.
Felicia: I understand but I was just concerned
that some of our larger business lines,
they have one TAS but they tend to do business
with trading partners from all of the different agencies.
Emily: Okay.
Felicia: So by document number in a given month,
that might exceed the lines of Excel.
Emily: Okay.
Felicia: If for example,
we pulled by 047X 4534 001, which is a revolving fund,
which is ASF, just supplies alone I would assume,
with just the supply program within that TAS,
but there other programs that, you know,
Fleet and other programs.
Emily: Yeah, sure.
So I can take this back and we can, you know,
it's something we can start to tweak and look into.
It's not, you know, I won't take that off the table.
So it's definitely something we can try to look into
to see if maybe there's a way we can like zip the file.
I mean there could be some other things we could do for this
to make it so you can pull that many and then go from there.
So I wrote that down and I can bring it back
to like our team and we can kind of talk through it.
Felicia: Thank you.
Alex: And Felicia, just this is Alex again,
the only thing I was gonna jump in and say,
you're probably referring
to the acquisition services fund TAS, right?
So I think when, from my experience,
that TAS probably had one of the greatest volume of activity
for cars transactions, I'm guessing.
Felicia: Right.
Alex: So we can definitely take a look.
Bob: That's the one, that's the one.
Alex: Yep.
-: And see I think, -: I'll get to-
Bob: I'm sorry, is that Jeff or Alex?
Alex: This is Alex, Bob.
Bob: All right.
And see, that was the point I was making in the chat is,
and to Felicia's point, she's spot on.
We have two, three big TASes
where there's a lot of cell activity,
where GSA is the seller,
but we need to have additional filters
that would allow us to grab specific groups,
because the volume is going to be tremendous.
As Felicia spoke on the ASF,
just supply is gonna be tremendous.
And then on the FBF side,
which is a different TAS, it's gonna be rent.
And so we really need to have additional filters
that would enable us
to kind of get a lower number of transactions.
Otherwise, it's gonna be hundreds of thousands of lines
just for one business line.
And if you add 'em all together, it's gonna crash the system
or it's not gonna be able to be accommodated
in Excel or some of the other tools that we use
If that makes sense.
Alex: Yeah, so we can look at that, Bob.
So basically, well, I gotta would be
more reporting parameters as far as before you,
the report actually generates versus filtering
and Excel once it's actually there.
Bob: And I would add,
I mean I think I asked this question previously
about the status because we're really gonna be interested
in being able to kind of evaluate, you know,
these are maybe in the works or, you know,
sitting with the customer for approval, stuff like that,
because that's all a part of the reconciliation.
We need to be able to see all of the records,
and specifically the status of those records,
because that will help us facilitate kind of looking
at our records within our general ledger and, you know,
look ultimately at the accounting entries
to make sure that at the end of the month, any given month,
that we've made the appropriate entries
for the different activity that we had.
And we fully expect our auditors
wanting to see that type of reconciliation.
So we're trying to be as proactive as we can
to make sure that we're pulling reports,
we're performing reconciliations
between that, what's in G-Invoicing
and what ultimately ends up on our general ledgers.
So we're gonna need essentially all of the records
that were initiated or performed against
or signed or approved during any given month
with the exception of the GT&Cs,
even though I'd still wanna see a list
of all open GT&Cs at any given point in time
if we requested it.
Alex: I got you Bob.
That sounds good.
We can definitely take that feedback back
and kind of discuss internally
to see what we could possibly do there
to kind of alleviate some of those issues
you're bringing up.
Bob: All right, thank you.
Jeff: Are there any other questions?
Okay, last thing I'll mention before I turn it over
to, I believe, Justin, I just wanted to call out that
in our most recent publication of the program guide,
we included a new page titled
Business Rules by Reciprocal Category
and it outlines those nine data points
that Alex referenced earlier in the call.
So if there's any questions around that,
I definitely wanted to call out.
We have this document on our G-Invoicing webpage
and I can provide a link in chat once I stop sharing.
But as you scroll down and click this program guide,
we have it in Word and PDF file versions
and it's on the very next to last page.
If you scroll all the way down up one page,
we have the buyer side and seller side business rules
and how we kind of roll these up
into those nine data points.
So just wanted to make sure everybody was aware we had that.
So the combination of the program guide,
the G-Invoicing report, and the ATB summary report
that will be discussed next
will definitely help you guys
in your reconciliation efforts.
So I think that's everything that I had this morning.
Justin: Good morning.
That's a good segue to lead into what the demo
that I wanna do with the G-Invoicing
and GTAS comparison report.
Can you guys hear me okay?
Jeff: Yes, we hear you.
Justin: Okay, let me share my screen.
I have just a handful of tabs or a handful of slides here.
Audience Member: Hey Justin,
if you wouldn't mind just speaking a little louder,
coming in a little low.
Justin: Okay, will do.
Can you see the slides I'm presenting?
Jeff: Yes, I can see the slides.
Justin: Okay, thanks.
So yeah, this, like I said, that's a good segue for Jeff.
You know, and here's a high level of the nine data points
that the G-Invoicing GTAS comparison report.
We'll be looking at over on the GTAS side of the house.
So you can reach out to us directly to GTAS team or Jeff
or the G-Invoicing website to get further details
on these nine data points.
GTAS currently has proposed analytical edits
to compare the GTAS data and the G-Invoicing data.
These are edits 184 through 191
and here's quick screenshots
to kind of gives a high level view of what those edits are.
This is, like Alex had mentioned,
this will ultimately be used as a metric
on the scorecard for significant entities.
They are still currently proposed analytical
and will not cause the bulk file to fail.
It's just providing data for physical
and the government market needed to reconcile
and may eventually become fatal in the future.
And I will provide a couple links
that gives you more information
out on our Fiscal Service webpage
and I'll provide that in the chat here in just a second.
So generating the report in GTAS.
This is a screenshot of the GTAS reports module.
Pretty straightforward.
The report will be located in the reports module
under the intergovernmental report type.
You would run it by the screen.
Noah: Can you speak up a little bit please?
It's still hard to hear you.
Justin: Okay, sorry, no.
Yeah, so this is the module for the GTAS report module.
So to get the report out of GTAS,
you would ultimately go
to the intergovernmental report type,
run the parameters that you are needing.
You would run it by period, ATB solution status,
and run by FR entity, you would choose
or select your FR entity and run the report.
Audience Member: Oh, excuse me, I'm sorry,
I'm really having difficulty hearing.
It's, I don't know, it's kind of like in and out,
like your voice is fading at some point.
Justin: Gimme one sec, lemme check the mic.
The mic volume.
Audience Member: Thank you, I'm sorry.
Emily: I'm not sure that that's on your end,
because I'm not getting the cut out over here.
Audience Member: Headphones may help as well.
It's some background noise.
Alex: Yeah, we're hearing some,
there's like some fan sound
or some wind type noise in the background.
I think if you could put a headset on perhaps,
that would help, or dial in with your phone.
Justin: Sorry, yeah, give me one second here.
Is that better there?
Audience Member: Yes, a bit.
Thank you very much.
Justin: Sure.
Okay, so let me share my screen
with the actual report itself.
Give me one second.
Can you see the report that's generated on GTAS
in Excel format?
Robert: Yep, we can see it Justin.
Justin: Okay, thank you.
So as you can see, there's multiple tabs
on the new formatted report that you can generate out
on GTAS for the GTAS invoice and comparison report.
The first one is the combined,
it has both GTAS and G-Invoicing breakout data.
You have a combined amount
and you included both the GTAS side
and the data that we interface over
from the G-invoicing side.
And you're able to compare the differences here
on this high level summary tab.
As you can see over here in columns A and B,
the GTAS statement number and the G-Invoicing breakout data
has linked lines to where you can dive into the details
of the data in the sum line
that's presented here on this combined summary tab.
It's similar to reclassified statements
that are generated out of GTAS.
They've recently included a breakout
of interdepartmental data versus intradepartmental data.
So this data here, interdepartmentals, obviously it is,
you know, data that's training within itself an FR entity.
So it's a different way to break down the data
of what is internal versus what is interdepartmental
with the government-wide community.
Same goes for the interdepartmental tabs.
They're linked and you can click on each link
whether you want to dive into the details
of what's coming over from G-Invoicing
or what has been submitted on the bulk file via GTAS.
So for a quick example, if you wanted to look at line 3.4,
we just click on line 3.4
and this will give you the breakout of the bulk file
that makes up that summary line
or that total line for that line amount.
The following tabs here, the GTAS bulk file,
this is accumulation of the entire bulk file data
that is used in the report.
Like Noah was was asking about,
this will give you some avenues to dive deeper into the data
of what is on the bulk file itself
versus what is being poured over from the G-Invoicing side
that you can see here on this tab as well.
The individual lines here,
you can go through the line analysis and provide,
it gives you a tool you can utilize
as you're doing the reconciliation process.
Additionally, you'll have the details
of the proposed analytical edits
that will provide the differences
that are occurring between the statement line
and the G-Invoicing data.
In general, that's a high level view of the report itself.
I know it was a quick demonstration, pretty self-explanatory
and provides adequate details to reconcile
as we continue with our effort between GTAS and G-Invoicing.
Additionally at year-end-
Sue: Hey Justin, do you wanna go back
to maybe one of the first three tabs real quick?
Justin: Sure.
Sue: I think it might be helpful to point out the legend.
This is Sue from St. Louis FRB.
When we were creating this report,
we work closely with the G-Invoicing team
and we were getting feedback from agencies
and we wanted to make sure
that we know some of the users for this report
will be familiar with GTAS but some will not.
And so we wanted to make sure that the legends were helpful.
So that's, you know, like a fiscal period in GTAS
is an accounting period in G-Invoicing for example.
So we wanted to make sure that the column headers make sense
so you understand what data you're looking at.
So I just thought it would be, you know,
might be helpful for users not familiar
with re-classified financial statement reports
to look at that just to make sure that, you know,
they can easily identify the data that they're looking at.
And just for a review, the manual adjustments being reported
as interdepartmental versus intradepartmental,
that's a new concept within GTAS from last year.
And so that's why we have three tabs breaking out this data,
because we wanted to make sure
that anything that was easily identifiable
is intradepartmental versus interdepartmental
was displayed here.
Justin: Thank you Sue.
Yeah, if you want to elaborate a little bit
on the manual adjustment data
that will be presented in the period 12 report as well
if you don't mind.
Sue: Yeah, sure.
Yeah, so manual adjustments are only for period 12.
So the column here,
obviously this is a report run for period three,
so you're not seeing any manual adjustments,
but when it is available,
these first three tabs will have that additional information
so you'll know what the manual adjustment amount was
for like a combined amount and then it will break it out
versus intradepartmental or interdepartmental
depending on if the agency is using itself
as a trading partner or not.
We do have, just as a reminder,
this data for this first year is gonna be filtered on a TAS,
that's a BPOA of 2023, to help with the mandate,
'cause that's really the only TAS data
that's of interest during this first year.
And to further help with manual adjustments,
we do have a coming soon feature
that'll be part of our year-end release.
We'll have a new tab called manual adjustments
and it'll be a culmination of all manual adjustments
broken out for their USSGL account number
and trading partner FR entity.
I do have a mock-up of that,
if I could just show that real quick.
So this will be coming soon
so you'll have a new tab for manual adjustments.
There was a request to include this
so it does have a nice breakout
of all the manual adjustments
and you can easily see which USSGL account number
and additionally the trading partner FR entity
and it'll just be all in one place.
So instead of it being broken out across all the tabs,
you'll see it right here.
And then the other request
was to include the trading partner FR entity
across all the statement tabs.
So like Justin was pointing out, all the different data,
there's just a different data table on each tab
that will also include in trading partner FR entity.
Robert: Okay, yep.
We do have a couple of questions in chat
that I did want to call out.
Been sitting on them for a few moments,
but just need a confirmation.
Justin, this one was from Susan Walton at FEMA.
She wanted to know if the reporting
only includes reciprocal categories 22, 23, and 24?
Alex: Hey Robert, this is Alex, I can take that.
Yes Susan, so any of the activity
that's being passed over by state line
are only those by cell reciprocal categories
of 22, 23, and 24 that we're comparing.
Robert: Thank you Alex.
And then we had another question from Catherine Kulfis.
What would the combined
comparison differences consist of?
Alex: So Catherine, I believe on that,
and Sue correct me if I'm wrong,
I believe the combined is a combination
of both the intra and interdepartmental tabs
to all be on long tab versus having them split out.
So I think those two are just combined on that.
But Sue correct me if I'm wrong.
Sue: Right, no, that's absolutely correct.
Yep.
Robert: Okay, so I think that catches us up
on our outstanding chat questions.
So what we can do is just open up the floor
for any additional questions
or maybe if there's anything that you wanna see
on the G-Invoicing side,
now would be a good time to ask that as well.
We can certainly go back to that portion and answer that.
All right, got a question from Rom at FAA,
will there be APA, excuse me,
will there be API support so data can be pulled
into financial systems for reconciliation and research?
So Rom, I can answer this from the G-Invoicing perspective
and, you know, it may be a similar answer from GTAS.
So our initial offering
is certainly through the user interface
and these Excel-based reports.
We don't currently have plans to offer this via API,
but, you know, if there are enough agencies
that have an interest in that,
it's certainly something that can be considered.
Alex: And Rom, I know from the the GTAS protective,
I know there's not really API connections
set up to run reports out of like the actual system there.
So I know that's not currently.
Users have to log in to pull those reports out
and there's not a API connection
for any of those GTAS reports
for external agencies currently.
Robert: Okay, I see there's a couple of hands up
and I'll get to you here in a moment.
I just wanna address one more in chat
and then I'll switch over to you Lisa.
So how long is ODNI exempt from using G-Invoicing?
So I just want to clarify there, ODNI is not exempt,
they're just delayed in implementing G-Invoicing
and we're hoping that sometime here in the near future,
we'll be able to share their plans
in terms of how they're planning on to implement
and come into G-Invoicing.
They're really close with their technical solution
and their plan for implementation.
So hopefully we'll have some details
that'll be shareable here in the near future.
Okay.
Alex: I know we got a couple more questions Robert,
I know I think Rebecca asked,
the comparison is not expected down
to the TAS sub-account level, correct?
So Rebecca on that, I guess any unique TAS
will be shown on the report.
And just to like, I guess make sure everyone's aware,
this isn't like a required reconciliation
that Treasury's requiring that you do,
it's really more of a tool we're trying to put in place
to help you reconcile any data
between your data that's being reported in GTAS
and what's being transacted in G-Invoicing
to kind of identify where the gaps are in that reporting
so you can improve your overall score
that is being displayed on your scorecard, so.
But we will give all the data that is being reported in GTAS
and data that's being passed across from G-Invoicing
and have that down to that unique TAS level.
The next question I see Robert, is I think from Scott Young.
Will there be any timing differences
between G-Invoicing in cars or records
or are the records updated real time in both systems?
So Scott, on that,
I think it was a question we had previously in the chat,
so the GTAS reporting's always done,
like so the March GTAS reportings happens in April.
So there's really a delay there
of when the GTAS reporting actually happens.
So I believe for G-Invoicing,
the period has three business days
after the close of the month,
so you have three business days to do that.
And with GTAS, the GTAS reporting doesn't open up
until the fourth business day.
So we interface in the G-Invoicing information in the GTAS
before the opening of the GTAS reporting window.
So the information that's being pulled from G-Invoicing
and GTAS should be finalized as that point for March,
because there's no changes that can happen
after that third business day.
And I see one more question and I think from DOJ,
can the data be downloaded like an ATB?
Yes, the data, like Justin was showing in the reports model,
the data can be downloaded into Excel format
that Justin was shown, but yes,
it can be downloaded from GTAS from the reports module.
Robert: Thanks Alex.
Okay, I'm going to switch to the hands that are up now.
So Lisa Deger, you're up first.
Lisa: Good morning.
I'm bet Alex and Justin and Wes
are probably gonna guess what I'm gonna say.
And that is that until G-Invoicing and GTAS
can include our limits or SAHIs, AID97 and 17,
are gonna have a very difficult time with reconciliations
with our trading partners and between our data.
So I know that there is a generic field
in the G-Invoicing that we're going to be using.
I can't tell you what that is offhand,
but I don't think it will be included
in the G-Invoicing report.
And certainly if it isn't in GTAS,
then we'll only have half the answer
if we ever get it in G-Invoicing.
So I would be remiss if I didn't take the opportunity
to mention that again.
Thanks.
Alex: Yep, yep.
I definitely appreciate the feedback on that Lisa
and we can take that back internally just take a look at it
and see how we can best help out with that.
But yeah, we understand that is an issue,
until we get that addressed both from the DOD side
and the Treasury side.
So we can take that back
and then if we need to have further conversations around it,
we can definitely do so.
Robert: All right, thank you Lisa and Alex.
Angela: This is Angela NRC again,
I did not understand what that was really about.
Can you expand a little bit please?
Alex: Angela, are you talking about on the DOD question?
Angela: Yes, please.
Alex: It's more of an internal DOD issue,
it's not a government wide issue.
It happens to do with their SAHI in their internal systems
and being able to reconcile back between the two systems.
But it's really not a issue
that's widespread across the government,
it's more internal to DOD.
But Lisa, correct me wrong, do you want me to do that?
Lisa: Yeah, I would say that
it is an internal structure to DOD, but it is an issue.
The 97 agencies of which there are, I dunno,
35 to 40 of them, under 97 each have a specific identifier,
which we would call a SAHI sub-account holder,
indicator, or a limitation.
And each limit or SAHI indicates which trading partner,
which defense agency you're doing business with.
We have shared main accounts, 0100, 0300, 0500, 0400,
so we had got shared main accounts, we've got a shared AID,
but we've got 30 plus agencies under the 97.
And so the reconciliation for us
would need to be at the defense agency level,
not the main account.
I mean, we can reconcile a main account, right?
But I can't tell you which defense agency
you would be doing business with.
Angela: Okay, so it's at the higher level
that NRC would be reconciling with not at that sub agency?
Lisa: I think it's at a lower level.
I think we are at a lower level, we have sub-accounts,
but I mean it's the next, I would call it the next step down
that helps us, say, whether you're doing business
with Missile Defense Agency,
or can file, or I mean all of them.
Robert: Yeah, Angela, it really gets to the fact
that a number of agencies share AIGs
and these are identifiers that DOD uses to make
or to delineate the activity.
So, you know, which defense agency
is actually executing that work
under the 0970 AID for instance.
Okay.
Audience Member: I have business
with Air Force for US transcom right now.
Am I gonna have an issue?
Lisa: If you work the 57th side of Air Force?
But I believe transcom has some under 97.
Audience Member: Okay, so that's what sparked my
or piqued my interest, right?
Lisa: Right.
Audience Member: When you said 97 and 17,
I'm like, "Ours?"
So.
Lisa: Yeah, 97.
Well yeah, 57's Air Force, so that shouldn't be.
But you will for transcom.
You would have, yes.
17 is Navy being, they have subheads as well as those.
Audience Member: Okay.
So going back to the beginning of what you were saying,
how will that impact NRC's GTAS reconciliation?
Lisa: Well, I think.
Audience Member: I mean it's a low dollar amount,
so overall it's not gonna have a high impact
on our score card, so I'm not utterly, you know,
overly concerned at this point in time, but you know,
I'm a small agency so there could be bigger agencies.
Lisa: I understand, yeah, yep.
It's an issue right now.
So It is not an issue that's going to go away at this time.
Audience Member: So are there any suggestions
for those of us who are trying to do a reconciliation
that we should look at, take into account, make note of?
Lisa: No, I think that, I mean for me,
I would say couple things.
If we get the limits in G-Invoicing,
they're already listed on any members or agreements,
on IPEC, they're in various locations,
so I couldn't direct you to an exact location,
but I would make note of it in G-Invoicing
and maybe, I mean to me, that's where you start, right?
Knowledge.
So then the next question is when you put input agreements,
are you inputting the limit/SAHI in into your system?
I mean, to me that's the biggest issue
that people don't recognize.
Agencies don't recognize a number
that they don't use, right?
And so where does it belong?
What is it?
Do I really need to record it?
And is it being recorded?
And so I would, I mean, that's...
And I think that G-Invoicing will help in that.
I hope that it's clearly delineated in there
when we are filling out our G-Invoicing forms.
I think that's a start to help.
Certainly we can talk, I mean you can call me anytime
and I'll reach out and we can talk further.
Robert: Okay, not to cut you off Angela,
but we do have one other hand up for Felicia Ford Jones
and I do wanna get to that.
Felicia: Good morning again,
I think that you answered this question, but I wasn't clear,
so I thought I would just re-ask
just to make sure that I'm clear in my head.
And the question had to do with the cutoff dates.
So I'm thinking is this report going to be official
as of a certain date?
Because I had some concerns before
because while G-Invoicing has its plus three
or at the end of the year, plus five cutoff dates,
GTAS has extension dates that could go, you know,
four business days or more out
depending on whether it's a month-end
or at the end of the year.
And I wondered how that is, you know,
accounted for in this reporting.
Is there a cutoff date that this is, you know,
that we should pull this report or how does that work?
And then I want to piggyback,
you had mentioned that the limit issue
is an internal issue to, you know, the military,
but it actually impacts those agencies
that do business with them and that in GTAS,
we don't have a way of reporting the limits.
And so those are the two things I wanted to mention.
Alex: So I can jump on the first question, Felicia,
and then we can kind of follow up on the second question.
So the first question, I know you kind of hit on
and I hit on it earlier as far as G-Invoicing
has a plus three and we'll interface the information in
from G-Invoicing and the GTAS
before the reporting window opens up
for the specific period for GTAS.
But like you mentioned, a reporting window in GTAS,
usually right now the new standard schedule
is we open up on the fourth business day of the month
and we have 10 business days for reporting happening
and then we have an extension window on quarter ends
for any proprietary corrections
during that extension window.
So I guess recommendation on that is you can run the report,
the report will be updated as you certify
and upload new information
during the GTAS reporting windows.
So you can run it during the window to kind of check that,
see if there's any corrections you need to make
in your ATB reporting during the GTAS window
before that window closes.
But if you're really looking for a final report out
on GTAS for the G-Invoicing and GTAS comparison report,
I'll run that after the extension window closes
or you guys know you're done with your reporting
'cause you know the G-Invoicing information
is not going to change, but obviously that GTAS information
can change up until the end of the extension window
on a quarter-end.
Felicia: Thank you.
And then the GTAS limits, that was just the comment so.
Alex: Yeah, and so I mean, I was just thinking of that
as Lisa was talking through that as well.
But really for the limit, is that more of a,
I mean the limit's gonna be more
on the IGT difference side
than not a G-Invoicing compliance side, right?
I mean, 'cause really, from what I hear there,
it's shared TAs in identifying the correct training partner
within a shared TAS and having that limit available
to properly reconcile
which training partner you're trading with
to make sure your IGT differences
are eliminated as much as possible.
But really, I mean, when we're looking at it
at a holistic view on a scorecard purposes,
it's at a holistic FR entity level
that we're rolling up that 097s or those shared TAS up into.
So anything that has a shared TAS
should roll up into that report for that FR entity.
But the limit, I know it's something we need to look at
and address, but I just wanna make sure
I'm understanding that correctly.
It's more of a training partner issue
to making sure that you are trading
with the correct partner
and eliminating those IGT differences as much as possible.
Felicia: Yes.
Alex: Okay.
Yeah, that's my understanding as well
and I know that that is an ongoing issue
that we are looking at it and note, we are aware of that,
we need to look at, but just wanna make sure
that I was clear on that, 'cause in my mind,
I was making sure my understanding was
it's not really a G-Invoicing compliance issue
and a metric issue, it's more of a trading partner
IGT elimination issue that we're talking about.
-: Okay, we do have one- -: So that's.
Robert: Sorry Alex.
I was gonna say we do have one more hand up
and it's Lisa Sawenko.
I'm gonna try to squeeze that in,
'cause we're right at the end of our time slot here.
But for anyone else that has unanswered questions,
I'm gonna drop a email address in chat.
Feel free to send them there.
And then Lisa, I'm gonna turn it over to you.
Lisa Sawenko: Can you hear me?
Alex: Yep.
Lisa Sawenko: Okay, so this is Lisa Sawenko
from the Department of Veterans Affairs.
I typed a question in the chat.
So how does this work, this reconciliation,
and then these edits?
I know right now, you're saying they're gonna be proposed,
which at some point I'm assuming in the very near future,
they will become fatal.
How is this gonna work for those agencies
that aren't in G-Invoicing yet
as far as the reconciliation goes?
Because obviously if we're compliant on our side,
but one of our, you know,
on the other side isn't in G-Invoicing,
how is this working?
Alex: Yeah, that's a very good question Lisa
and I know it's something that we've thought
about in the past.
But ultimately, if your training partner
isn't in G-Invoicing,
that activity's not going through G-Invoicing,
it's going to lead to a difference
between what's happening in your GTAS reporting
and what's actually being G-Invoicing.
So I mean as you pull these reports and do that,
do those reconciliations,
that's something I think you could call out
and say, "Hey for VA, if we were transacting with,"
I'll say like DOI for example,
they're not currently in G-Invoicing,
we know that's a spot where the activity
is flowing into GTAS but we don't have that activity
in G-Invoicing and that's a portion of our activity
that's not being captured in our overall compliance metric
for G-Invoicing.
So we know those examples are happening
and those are probably conversation pieces we're gonna have
during the scorecard meetings
to talk about your G-Invoicing compliance metric
and talk about, "Hey, some of the issues that we see,"
is whether that's training partner readiness
and other things, but we know that is going to be an issue
and that is going to be reflected
as far as a difference between what's being reported in GTAS
and what's being transacted in G-Invoicing.
Lisa Sawenko: Okay, and then I know,
I believe it was Robert responded to my other question
as far as this is only available currently
in the G-Invoicing, but because this is in relation to IGOV
and IGC or IGT differences,
it would really be beneficial if this report somehow
was available in the GTAS side similar to the IGOV reports
that we have now to check all our reciprocating categories
because this ultimately would flow into there.
Alex: So make sure, I'm on the same page there
with you Lisa, I know the GTAS reporting functionality
is out there currently, but as far as the IGOV piece,
what do you actually meaning there as far as-
Lisa Sawenko: Like to be able to see the details
on the G-Invoicing side.
I don't have access,
nor I don't need access to G-Invoicing.
So for me to be able to get this report,
obviously I can coordinate with my team
that works the intergovernmental stuff
and G-Invoicing to obtain the report,
but it'd be beneficial to be able
to not only see the IGOV report,
but then be able to see the other side
that the G-Invoicing piece that might be causing this,
you know, the difference,
the reciprocating category difference.
Alex: Okay, yeah, we can definitely look at that
and see if we can help you as far
as getting access to G-Invoicing
or somehow getting those reports out there
to help out that issue, talking about Lisa.
But we can definitely talk more about that offline
and see what kind of solution we can come up with for that.
Robert: Okay, well with that being said,
we are over time so just wanna respect everyone's calendars.
So thank you for your participation today.
Again, if you had questions
that we didn't get to or did not answer,
I did drop an email in chat
and then this is a recorded session
and we will make it available on the fiscal service website.
When we're able to publish that,
I will send out a note for everyone.
So thank you for your participation today again
and have a great rest of your week.
Alex: Thanks everyone.