SSBCI Capital Program Quarterly Report Template Demonstration June 24th

U.S. Dept. of the Treasury
26 followers
1 Video View·Aug 13, 2024
This video covers a demonstration of the SSBCI Capital Program Quarterly Report template.
thank you sue um so I will be going over
how to enter your information in the
template um something I want to flag is
that these are customized quarterly
reporting template every jurisdiction
will receive their own customized
template with a lot of data prepopulated
to reduce your data entry um and these
will all be made available to
jurisdictions before the opening of the
submission window um so please make sure
you're using your correct template to
report your
information um so as I mentioned there
will be a lot of pre-populated data on
your templates if you are a firsttime
reporter your pre-populated data will
include your reporting Period start and
end date submission deadline the name of
your participating jurisdiction your
total potential allocation the
accumulative funds dispersed to your
jurisdiction as well as a list of your
approved programs their programs types
their program administrators and their
program allocation you will also have
some basic information on your
administrative costs such as your
administrative cost threshold um if you
have any contracted entities you will
also have a list of those at the bottom
um and that will all be pre-populated
for you if you are a firsttime reporter
if you are
reporting I sorry can I can I interrup
second can you make the screen a little
bit bigger I think it's quite hard for
people to
see thank you thank you
so is that better for
everyone
okay perfect um sorry about that so if
you're a first-time reporter you'll have
all of those fields filled out um but if
you are a subsequent reporter you will
have additional information such as your
cumulative as of Prior quarter end data
if you've reported that you've eot funds
in the past you will see that populated
here as well as if you've reported
anything for your recycled funds eot
you'll see that here as well as any
reporting for administrative costs
program
income um and all of that information um
so we'll try to fill out as much of this
reporting template as we can for you
um so you've probably noticed that there
are two different colors on this
template you've got this gray and the
white so the gray columns will all be
locked um that will contain your
pre-populated data and you will not be
able to edit them but we do expect you
to fill out your data in the white
columns where applicable so if you ever
forget what data what columns you need
to enter data in just remember that it's
the white columns that you will see here
um on all these different sections
um and also to make filling out your
template easier we have included tool
tips for as many fields as we can
basically if you Mouse over one of these
fields you will see um some information
that tells you about what data that is
collecting or showing so for example you
can see it for the total potential
allocation it's the sum of all potential
allocated funds with the breakdown um
here it includes main capital SE SE
incentive vssb allocation um most of
these come directly from the reporting
guidance so that is another great tool
to use when you are filling out your
quarterly report if you have any
questions about the data that you should
be
reporting so looking at this template um
a bit more in detail now we can see that
there are several different sections the
first section will be some generic
information with your reporting Period
start and end date deadline in the name
of your jurisdiction um I am you know
using testing data so you will see your
actual jurisdiction's name here not just
sample PJ this second section will be
your program information and program
allocated funds expended obligated or
transferred you'll see your total
potential allocation the funds you have
received again that list of approved
programs that information as well as
this is where you will fill out your
program allocated funds
eot and then below that section you'll
see the administrative section and this
is where you will report your direct
administrative costs your indirect
administrative costs um and you'll see
also your administrative cost
threshold um all right here and then you
have your other required information
such as program income cap charge offs
you'll report all that here here and you
have a section for additional
information right here um so you can
leave comments um as required or as you
would like um and then we also have the
contracted entity information at the
bottom if you have any contracted
entities you'll see a list of all of
their names as well as the budgeted
amounts um you're able to edit that
budgeted amount um if
necessary so that is the template
so now I will go through an example of
reporting some funds eot for your
different programs so we are going to
start with our first program it's a
sample loan guarantee program um it's
been we've allocated 46 million to it
you have spent you know about 1.5
million so let's say this quarter we are
going to eot 10 million to this
program you're just going to want to
enter that right there and when you
click out of it you'll see that it has
started to Total at the bottom right
here and it has started to also increase
your cumulative as of current order data
so you'll see that all right there as
you enter your data next we're going to
move to our sample investment initiative
this is a equity Capital program funds
um and as Sue mentioned earlier for your
Venture Capital programs please make
sure to include your 171 fees um in your
while you're reporting so we're going to
say that we have eotd $8 million for
this program and we're going to include
that
here click out of
it and you are going to see that gives
us an error so we have built this
template to prevent you from entering
data that is not correct or you know
unlikely to be correct um so if you
enter data that is not you know
acceptable at the system you will get an
error and the error will give you you
know a list of possible options so we
can see number one the first possible
option is that the input must be numeric
we've entered a number so you know we
can see that this is not the cause of
the error number two a current quarter
amount must be positive we have entered
8 million which is a positive number so
we can see that is also not the cause of
the error number three current quarter
amount plus adjustment in cumulative as
of Prior quarter end exceeds program
allocation we have been allocated 100
million for this program and we have not
come close to meeting that allocation so
we can see that that is not um the cause
of this
error and then the last option would be
reported eot exceeds funds
dispersed so that is the cause of our
error and we can see that because we
reported 10 million for this first
program which puts that at it's cut off
but it's roughly
53.3
million um and if you add add 8 million
to 53 million that puts us above the
funds that we have received that is over
$60 million and it is not possible to
eot more money than you have been
dispersed which is why it is giving us
that error so we are going to hit retry
and we are going to enter a number that
is lower let's say let's try five
million this time we're going to click
out of that so we can see here that we
did not get an error but this template
is showing some red shading so red
shading also indicates you know a
potential error in the data you have
reported please do not submit your
template with any Fields colored in red
um this indicates that somewhere your
data is incorrect and it does highlight
you know the pieces that would be
helpful in determining what this error
is if you cannot figure out why your
template is in red please reach out to
either your Outreach manager or another
member of the ssbci team and they will
help help you resolve that issue but do
not submit your template with red
shading so we're going to look at these
two columns that we see or fields that
we see here in Red so we can see that
it's the total cumulative as a current
quarter it's 58 million which is below
our 60 million so that itself isn't you
know the only cause of the issue and
then we can see here this 2.8 million
which is the total for administrative
costs is asso shaded and we can see okay
these com in combination the issue 58
million plus 2.8 million is over 60
million so between you know the program
allocated funds eot and the
administrative costs eot we are again
saying that we have spent more money
than we have received um which is not
accurate so this is the same issue as um
the error before but so shown in a
slightly different
way so we are going to go back to this
and we're going to edit this number and
say let's bring it down to $2
million and we can see that that error
will go
away and then let's say that we have
spent 1 million for our um Capital
Access
program okay so that is an example of
filling out um the program allocated
funds eot um for your different programs
um you will get you know errors and SE R
sheet ating if you have entered data
that is unlikely to be
correct moving over to the Recycled
funds eot section um for those of you
who are reporting recycled funds eot you
would want to fill out this section just
like we filled out the program allocated
funds
eot and you will see it some across as
well all right so now we are going to
move into the administrative costs
section
um so we can see some basic information
about the administrative costs so we can
see that we have eot at 2.8 million in
the past in that our threshold is just
over three million um so for your first
trch dispersement your administrative
cost threshold cannot exceed 5% of your
dispersement um and we can see here that
ours is at
4.97% um and we have you know expended
very close or we have eot um 4.67 % so
very we're very close to hitting that
threshold but let's say in this previous
quarter I in this current quarter I have
ex eotd
$600,000 if I want to enter that here we
will see that it will give me an
error with a few options as well um our
cause of the error is option number
three total administrative costs cannot
exceed administrative cost threshold by
expended 600,000 in this current quarter
that will put me you know significantly
over my threshold and that is not
allowed but as Sue mentioned you are
able to offset your administrative costs
um through program income so let's first
move down then to our program income
section right here at the bottom um so
you can see that previously I've
reported 600,000 of program income and
let's say in this current quarter I want
to report another 200,000
of program income so I'll enter that
here and it'll total up to the
800,000 so I said that I wanted to you I
wanted to expend report you know 600,000
for direct administrative costs in this
current quarter I can then make an
adjustment to my program income by
entering a negative number or a number
in parentheses and use that income to
offset my administrative costs so I'm
going to enter
500,000 here
and use that to offset my administrative
costs so you'll first want to enter it
in the program income adjustments
field and then you'll want to move up to
your administrative costs and enter that
adjustment up
here you need to make sure to enter that
adjustment on both um columns as Sue
mentioned earlier and then once I've
made that adjustment I can go ahead and
report my 600,000
of administrative
expenses and we can see that that does
not give me an error it accepts me
offsetting my administrative costs with
program
income so that is an example of
offsetting your administrative costs
using program
income um so then you would want to fill
out if you have any cap charge offs here
before moving down to the comment
section so here is where you would leave
any comments regarding your early report
you are required to leave comments if
you have made an adjustment which in
this case we have made an adjustment and
we have used program income to offset
administrative costs so you would want
to leave some detailed information about
what you did we're just going to quickly
write program income used to offset
admin costs but please be detailed um in
your
comments and then we can also edit the
budgeted amount for the contracted
entities
below and that is the majority of the
data that will be entered on the
quarterly report however there are a few
other instances where you might need to
enter adjustments you know as directed
by the ssbci team if you are processing
an unenrollment as you discussed earlier
um once your unenrollment has been
completed you will rece you will have
received notification from the ssbci
compliance team regarding that you would
want to report the adjustment for the
applicable program up here um so if it
was 20,000 or however much you know the
cost of however much the transaction was
that is being un enrolled you would want
to report that in the adjustment and
make sure to enter it as a negative
number
um and that um adjustment would also be
would also require a um comment in the
comment section here um but again you
will be directed when to make those
adjustments by the ssbci
team um so that concludes my
demonstration of the querly report
template um does anyone have any
questions if there are no questions I
just want to highlight what um aan said
and Su said as it relate to the
adjustments on um on
enrollment um the qut reports are only
capturing ssbci amounts so please only
unenroll the portion of the ssbc that's
being removed from the transaction um
but I think we have some questions so
I'll stop talking um please feel free to
come off mute um I think I saw a couple
of people raise their hands um doing
hi uh this is Dwayne Thomas with the St
ridges Mohawk Tribe we have just got our
allocation so we haven't done anything
yet so are we just gonna put zeros in
for this first
report yes but if you have if your funds
are being held in an interest baren
account you should also report any
interest that you have a code within
that period if
applicable
okay thank you for the question
Allison hi Mama
um regarding Anya's adjustment for the
program income used for
admin when you go to the comment under
direct admin it states um dollar amount
of allocated funds I thought we're
only reporting funds used for admin
that's part of the allocation program
income is not part of the allocation
program income is any funds that you
acove from the allocation such as
interest or any that you receive um so
that's what's in reference
to program
income but I thought the allocation
total was what's
in sell d11 that doesn't
include program
income well that that that was in D um
um an can you shift back up to d11 I'm
sorry so that's your potential all um
thank you a that's your potential
allocation so that's what you are you
potentially can receive within your
three
dispersements and that's um the um
column 13 is your current um
dispersement your yes so I wouldn't I I
wasn't including program income used for
admin as part of allocated funds because
it wasn't part of that total potential
allocation and that makes sense you
might use your program income for Access
of the the the threshold of the um admin
card so if your your current your first
CH is 5% so if you use any amount in
Access of that 5% you can use program
income for but program income is not
factor in in that amount
if that's what you're asking I'm sorry
Al okay thank
you okay thank you for the question
appreciate it um if we don't have any
more questions an I will turn it over to
you sorry for kicking over to turn over
to Jay thank you
