SSBCI Capital Quarterly Report Training Introduction to the Quarterly Report June 24th

U.S. Dept. of the Treasury
26 followers
4 Video Views·Aug 13, 2024
This video covers the process of downloading, uploading, certifying, and submitting the quarterly report in the reporting portal. This video also covers Q&A regarding the SSBCI Capital Program quarterly reporting.
good afternoon
everybody we'll give um folks a few
minutes to join thanks for joining
today
hello hello good afternoon
all good afternoon
I think we still have some folks coming
in um hello everybody my name is May
maaba um thank you so much for joining
us today for the ssbci um Capital
Quality Reporting training on for Q2
reporting
um just for everybody's awareness we're
going to record this training so we can
share it you can share with your team
members and any new hires on your team
or you can reference it as you complete
your Quality Reporting training for
quarterly reporting for Quarter Two and
our data is due by July 30th
um okay we can get go ahead and get
started again our goal today is to walk
everybody through the process for um
completing and submitting your quarterly
reports um and not just showing us your
eot data your extended obligated data as
of um um as of I'm sorry as of um
um June 30th I'm sorry for reporting
period for um April 1st to June 30th um
and this report um reporting window will
open a um July 1st and then will'll
close July 30th and just for correction
this is for reporting period from April
1st um to June 30th and um the reporting
window will open July 1st and you have
until July 30th at 11:55 p.m. eastern
time to submit your quarter reports this
training does include folks that are
going to report for Quarter Two also we
invited folks that are going to report
for the next um quarter which will be um
they will report until October which is
quarter three reporting um throughout
this training we will um Reserve time
for questions but we also ENC encourage
you to submit your questions via the
chat um or just come up mute um and you
know jumping with your questions um
throughout the
conversation um if you want to get any
written responses to your questions we
will encourage you to send them to the
mailbox which is
ssbci moreinformation treasury.gov and
we just ask you to please include your
aage manager on that
communication so I'm going to turn it
over to my colleague um who will lead
this session today St Chang um on the
compliance team will provide an overview
of the Quality Reporting requirements it
will also highlight some best practices
related to reporting program income
administrative expenses and tips and
other things that will be useful related
to adjustments and also explanations for
adjustments um i s senson will also walk
us through the template um and she will
provide how to complete all the
different um buckets of the template eot
data expand and obligated data related
to your all your approv programs um also
she will walk you through the um admin
um administrative cost reporting and any
program income related and any
adjustment so she will do a highlight
all the things that Sue talks about um
related to the template um Jay Flowers
will walk you through a demo of how to
access your template and submit it in
the reporting portal and we'll ask
everybody especially for the new folks
we do encourage you to um go and access
or check your access related to the
portal to make sure you can download
your template and start playing with
that and make sure any data um any um
application related data um is um
correct so please do that um even doing
this call Jay will encourage you to do
that um and of course um Raa Mamud will
jump in and she will provide some of the
good um Q&A so we encourage you to stay
on um we made this session a little
longer and we do appreciate your
patience with this process I will stop
talking and turn over to my colleague
such Chang who will walk you through an
overview of the reporting process and
again please jump in with any questions
and we do appreciate your time today
thank you
everybody the floor is yours thank you
thank you Mayma uh thank you um thank
you and thank you for joining today's
clue reporting training um as M
mentioned I will provide an overview of
the clo reporting requirements and we'll
cover some of the data elements on the
clo report um and then on will follow um
after that with demonstr on the complete
on completing the template um so we'll
start with the first slide on what is f
reporting thank you um the capital
reporting guidance sets out reporting
requirements for jur jurisdictions that
receive ssbci funds uh to facilitate
your reporing requirement treasury has
created a customized reporting template
for each
jurisdictions um and we and we
prepopulated some of the data Elements
which on will go into detail later if
any of the pre-pop data is incorrect or
incomplete please let us know before you
submit your qu report uh there are six
stated elements to the quote report
template that that the jurisdiction
should to complete and they are shown on
this slide um again Anya would
demonstrate these six dat elements later
in the presentation we encourage
jurisdictions to re U to review the
capital guidelines and capital guidance
on specific data to
report um we will move on to the next
slide on when are Court reports due to
treasury um cour reports must be
submitted to treasury three days after
the end of the qu reporting period um
for second quarter reporting the portter
will open for submission on July 1st and
closes on July 30th uh we will send out
email reminders to all participating
jurisdictions that are required to
report at the beginning of the
submission window and will send
additional reminders prior to the
submission
deadline um moving to the next
slide um each jurisdiction is required
to submit a quote report starting with
the quarter after the signing of your
allocation agreement
so for example if a jurisdic
jurisdiction do signed the allocation
agreement in January which is in q1 your
first quot reporting requirement starts
in Q2 and for jurisdictions that sign
the allocation agreement in qu in the
second quarter you are required to
submit your quote report starting in the
third quarter the second quarter
templates are currently available for
download for all jurisdictions that are
required to report for quarter ending
June 30th
the submission deadline for second
quarter close falls on July
30th um but jur can upload the completed
template at any time during the
submission
window okay we will move on to the next
slot on eot um eot which is expended
obligated or transfer um the first point
um I want to clarify is that only ssbci
funds are reported on a c report that
should not include any private capital
capital
starting on the left for expended for
transaction to be considered expended SS
ssbc funds must be dispersed to a
specific borrower and a direct lending
companion loan transaction dispersed to
A lender as part of is set aside to
cover a loan guarantee flow deposit or
purchase participation for a specific
transaction that has closed for a cap
transaction funds deposit with the
lender to the cap Reserve account or for
a VC and Equity direct transaction sspc
funds must be directly invested in a
specific
business uh moving to the next column
obligated um for transaction to be
considered
obligated um SSB funds must be committed
pledge of promised and writing to a
lender or a borrower as part of a loan
participation that has not closed or
committed a pledge or promise and
writing to a lender to cover a loan
guarantee and Cloud deposit um and the
low has not yet closed U for direct
Equity
investment an obligation is assigned
term sheet committing the capital but
the funds have not been invested in this
in the business and for VC fund
investment a commitment to a VC fund
through a sign a LPA agreement and note
that the obligation is at the fund
level in the last column we have
transfer the main thing to know for
transfer ER is that there should be a
documented need to fund a loan
transaction or investment or to pay for
allowable
expenses okay we will move on to the
next slide um on reporting program eot
administrative costs um program funds
eot should only include loans investment
and funds to be used for 171 fees for
services for for portfolio companies all
other expenses are considered
administrative and should be reported in
the administrative cost field therefore
BC commitment cap BC committed uh
capital for administrative cost should
not be included in the program funds
eot okay we'll move on to the next slide
on reporting DC Comm BC fund
commitments um DC operating expenses
such as fund formation cost should be
reported as administrative cost in a VC
fund transaction the budgeted amount the
budgeted operating expenses should be
subtracted from the total commitment
amount and the amount expended for VC
operating expenses should be report as
admin
eot um I will take you through an
example of a BC uh commitment reporting
as sh on this slide we have a
jurisdiction that makes an ssbci fund
commitment of $1 million to a v to a
venture fund this is represent is number
one on the slide the 1 million
commitment includes one1 fees and
operating expense budget
the this so that's what represent is two
and three the 171 of 171,000 admin cost
the budget it cost of 36,000 the program
eot that should be reported on the Cod
report is the commitment amount minus
the budget budgeted operating expenses
the commitment amount is 1 million and
the operating the budget operating
expenses is 36,000 which gets you to 964
th000 that's this is the amount that
should be reported on the program
allocated eot line of the quot report
the adding cost that should be reported
on the quot report should be the actual
encor Opera expenses so this is the
expended amount in this example the
jurisdiction should report 5,000 and
funds eot for administrative cost it's
just shown as item four on the on the
slide okay we'll move on to the next
slide on reporting program income okay
program income receives by the jur
jurisdiction that is directly generated
by an ssbci supported activity or earn
as a result of SSP funds during the
program period should be reported in the
Cod report and interest earned on SSB
funds not invested or lent to small
businesses count as program income and
should also be reported in the career
report um and when there is an income
gener generated by an improved program
that includes non ssbc I jurisdiction to
report only the Prat share of the income
that is attributable to
ssbci uh the last thing I want to point
out on this on this slide is that for
jurisdictions that have program income
earn but have not been reported in the
prior quarter May report the prior
quarter income as an adjustment on the
courter
report okay we'll move on to the next
slide on program income administrative
expenses jurisdictions May offset
administrative expenses for program
income provided that there's sufficient
program income for the offset program
income and administrative cost should be
both be reduced by the amount of offset
as shown in this slide okay so in this
example in the second quarter
jurisdiction a used
$250,000 of program income to offset
administrative cost but
$250,000 should be shown on both the
program income line and the admin line
on the Cod report and should not be
netted against the Q2 program
income we want to highlight that any
admin expenses that have that have been
offset by program income cannot be
counted towards the eot requirement for
your subsequent trunch request so please
keep this in mind we are often any admin
expenses using program
income okay we will move on to the next
one on Recycle funds thank you um ssbci
funds are only consider recycle funds
once the funds are redeployed into new
loan into new loans or investment until
the funds are redeployed into new loans
or Investments jurisdiction should hold
off should hold any return aset We that
invested Capital um as an example a
$100,000 loan repayment should be
reported as a recycle funds once the
funds are redeployed into a new loan um
or for return invest for return invested
Capital the return of of capital should
be be reported as recycle funds once is
redeployed into a new
investment okay we'll move on to next
one adjustments to cour
report um for jurisdictions that are
reporting for the first time you should
not have any adjustments to your report
but you may have adjustments in the
future quarters um acceptable reasons
for adjustments include remov an obliga
loan or investment that that is no
longer sped to close correcting a
clerical errors error such as trans
transposition R number or when directed
um by
ssbci um if a jurisdiction has large
adjustments or swings uh from one Court
to another we recommend letting us know
before submitting your code report uh we
have if you do have adjustment to report
please provide a brief explanation for
the adjustment in the additional
information section of the code report
um we have
included on this slide some examples
that you may consider when providing
explanation while there's no character
limit uh the explanation should be brief
and to the point and should include in
the an explanation regarding the full
amount of the
adjustment okay moving to the next
slide okay for jurisdictions uh
reporting for the first time um and have
eot from a quarter prior to the First
full reporting period jurisdiction
should report the prior quarter activity
along with the current quarter activity
in the current quarter field for example
every jurisdiction execut the allocation
agreement in January which is and q1 and
eot funds of $1100 for the lpp program
and during the second quarter which is
the first time the jurisdiction will be
reporting the jurisdiction eot funds of
$200 for the second quarter reporting
the jurisdiction should input $300 in
the current quarter input field another
example would be if a jurisdiction has
programed income from the quarter prior
to the required reporting period the
jurisdiction should report the prior
quarter income along with the current
quarter income and the current quarter
field of the quot
report okay moving on to the next slide
um the next three slides will be on
unenrollment um but for
jurisdictions um that may wish to
unenroll um a close or use of Min
expenses uh when a jurisdiction
identifies a non-compliant use of funds
however treasury R approv is needed
before a jurisdiction can underr a
non-compliant
transaction if a jurisdiction identifies
a non-compliant use of ssbci funds the
jurisdiction should notify treasury
prior to taking any unenrollment in
management action even if the if the
transaction has not been reported to
treasury okay next
slide um until the unenrollment process
has been completed jurisdiction should
be using should be using the modified
certification on the use of funds when
submitting a quote
report if you have potential non-
compliant transaction and you don't see
the modified SP language in section four
of the portal please reach out to your
Outreach manager immediately and we will
work with you to change the modifi
certification and the portal before you
submit your code report uh Jay will
cover the certific certification process
in the portal later in the
training when the unenrollment process
is completed jurisdiction should then
report the amount of the unenrolled
transaction as an adjustment on the Cod
report a completed unenrollment process
includes the additional approval from
treasury to underrot the non-compliant
transactions and documentation showing
the replenishment of funds um we advise
jurisdictions to reach out to your
Outreach manager to discuss any
potential non-compliant
transactions okay um in the next slide I
will go over an example of a timeline
for jurisdiction going through an
unenrollment
process so jurisdiction a identifies a
non-compliant transaction in May which
is during Q2 the Juran contacts the
Outreach manager letting them know they
have potential non-compliant transaction
and provides details the transaction and
the jurisdiction's intent to
unenroll um and in the second quarter
which is in June which is still in the
second quarter the jurisdiction receives
a conditional approval from treasury via
email the conditional approval contains
instructions for jurisdiction to to go
about replenishment replenishing the
relevant ssbci program account and
documentation for
replenishment uh jur day then J A then
replenish the ssbci account at the end
of June which is we're still in Q2 and
send of documentation and certification
in July which is after the reporting
period for second
quarter but before the submission
deadline okay with that we're going to
go through
um these three
questions um does jurisdiction a need to
submit a modified certification for Q2
reporting the answer is no because the
replenishment took place within the
second quarter
reporting okay the second question is
does judg a need to report an adjustment
for second quarter reporting for the
amount of unroll
transactions okay the answer is yes um
if the transaction has been previously
reported to ssbci the jurisdiction need
to report the amount of the underall
transaction as an adjustment on the
second quarter
report okay the last question is does
jur a need to submit a modifi
certication for second quarter reporting
if the if jurisdiction a replenish the
account ssbci account in July keep in
mind this is after the the second
quarter reporting period before the
second quarter submission
deadline okay the answer should be yes
since the replenishment took place
outside the second quarter reporting
period jurisic a would need to submit
and modify
certification okay um so that's the
reception un moment um we will again we
advise any jurisdictions to reach out to
your Outreach manager to discuss any
potential non-compliant
transactions um okay we'll move on to
the next slide uh on some tips um on
this slide we put together a few C
reporting tips that you may find helpful
when you complete your C report your C
report contains um data validation and
conditional formatting which Anna will
show you later in the present
presentation the most important thing to
note is that please do not submit your
qu report if any of the fields are read
you're unsure how to correct the fields
that are read please reach out to your
Outreach manager before submitting your
code
report um okay we will move on to the
next
slide um on accessing the Cod report um
okay a different a user will have a
different level of access based on their
assign role in the portal um and Jay
Flowers will be will go over the
different levels of access in his
demonstration later want to highlight um
a few things on different levels here um
the most restrictive role is the account
administrator um and the leas is
restrictive is the account
representative role the account
representative role can view download
upload complete report and is the only
user who can certify um and submit
report report and if the user does not
have an authorized representative role
um an error message will appear
preventing the user from submitting the
report um and that concludes uh my
section um of the presentation I'm happy
to take any questions you can go off
mute or feel free to drop your questions
to me in the chat um and also you'll
have opportunity to ask questions L
later um at the end of the training as
well so you'll have to ask uh right now
if you and think of any um but feel free
to um go off mute if you have questions
thank
you okay
um you don't okay there don't have any
questions um I
will once twice no okay well I will pass
over to Anya now who will go over how to
complete the template thank you so much
