FY25 Wisconsin State PCard Reconciliation Calendar.xlsx

XLSX spreadsheet 70 KB Posted

Attached to
Purchasing Card Solutions: Purchasing Card, Travel Card, One Card
Contract number
505ENT-M21-PURCHASCARD-01
Issued by
Wisconsin

About this file

This document is a comprehensive FY2025 Wisconsin State Procurement Card (PCard) Reconciliation Calendar issued by the State Bureau of Procurement (SBOP) in partnership with the State Controller's Office (SCO) within the Wisconsin Department of Administration (DOA). The calendar covers the period from July 2024 through June 2025 (FY25) and outlines billing cycles, approval dates, and reconciliation processes for state employees using procurement cards. The system involves various stakeholders including cardholders, agency PCard reconcilers, agency PCard approvers, agency PCard administrators, accounts payable processors, state maintainers, US Bank as the card issuer, and the State Controller's Office for final payment processing.

The document establishes a bi-weekly billing cycle system with 26 billing periods throughout FY25, with specific dates for transaction reconciliation, approval deadlines, voucher corrections, and bank payments. Key operational parameters include Wednesday as the first day to reconcile transactions in PeopleSoft, Thursday at 5:00 PM as the force approval deadline for agency transactions, Tuesday as the final day to correct voucher processing errors, and Thursday as the scheduled bank payment date. The calendar identifies June 20, 2025 as the last day to make purchases in FY25. The system incorporates automated processes through PeopleSoft for transaction staging, budget validation, voucher building, and payment processing, with built-in error correction periods and escalation procedures to ensure timely payment to US Bank while maintaining proper fiscal controls and documentation requirements.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

CALENDAR TEXT

FY2025 STATE PCARD BILLING CYCLE AND APPROVAL DATES
SUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISAT
JULY 2024123456AUGUST 2024123SEPTEMBER 20241234567
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
7891011121345678910891011121314
1st Day to ReconcileForce Approval1st Day to ReconcileForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
141516171819201112131415161715161718192021
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
212223242526271819202122232422232425262728
1st Day to ReconcileForce Approval1st Day to ReconcileForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
28293031252627282930312930
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
OCTOBER 202412345NOVEMBER 202412DECEMBER 20241234567
1st Day to ReconcileForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
67891011123456789891011121314
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
131415161718191011121314151615161718192021
1st Day to ReconcileForce Approval1st Day to ReconcileForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
202122232425261718192021222322232425262728
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
272829303124252627282930293031
1st Day to ReconcileForce Approval1st Day to ReconcileForce ApprovalVoucher Corrections
JANUARY 20251234FEBRUARY 20251MARCH 20251
Bank PaymentBilling Cycle EndBilling Cycle StartBilling Cycle StartBilling Cycle Start
56789101123456782345678
1st Day to ReconcileForce Approval1st Day to ReconcileForce Approval1st Day to ReconcileForce Approval
1213141516171891011121314159101112131415
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
192021222324251617181920212216171819202122
1st Day to ReconcileForce Approval1st Day to ReconcileForce Approval1st Day to ReconcileForce Approval
26272829303123242526272823242526272829
Voucher CorrectionsBank PaymentBilling Cycle EndVoucher CorrectionsBank PaymentBilling Cycle EndVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
3031
APRIL 202512345MAY 2025123JUNE 20251234567
1st Day to ReconcileForce ApprovalForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
678910111245678910891011121314
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
1314151617181911121314151617151617181920*21
1st Day to ReconcileForce Approval1st Day to ReconcileForce ApprovalVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start
202122232425261819202122232422232425262728
Voucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle StartVoucher CorrectionsBank PaymentBilling Cycle EndBilling Cycle Start1st Day to ReconcileForce Approval
27282930252627282930312930
1st Day to Reconcile1st Day to ReconcileForce Approval
First Day to Reconcile and Approve PCard Transactions
-WEDNESDAY-Last day to Reconcile and Approve pCard Transactions

-FORCE APPROVAL-

-THURSDAY- Last day to Correct Voucher Processing Errors

-TUESDAY-

First Day Transactions are available for reconciliation and approval in PeopleSoft. PLEASE NOTE: Transactions that are first available on this day are NOT included in Force approval the following day, but are included in the force approval 15 days later. Reconcilers, Approvers and Agency Adminstrators have until 5:00 PM on the Thursday after the Billing Cycle End Date to Approve PCard Transactions. State PCard Maintainer approves any remaining transactions starting at 6:00PM. Approved PCard Transactions are Built into Vouchers starting at 7:00 PM. Last Day for Agency PCard Administrators and A/P Processors to Correct PCard Voucher Pre-Edit, Recycle, and Budget Check Errors.

BILLING CYCLE START DATE BILLING CYCLE END DATE SCHEDULED BANK PAYMENT Legal Holiday ** FY25 LAST DAY TO PURCHASE

*Please Note that June 20 is the last day in the last billing cycle for FY2025.

CALENDAR SHAPES

FY2025 STATE PCARD BILLING CYCLE AND APPROVAL DATES
SUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISAT
JUL 2024123456AUG 2024123Sep 20241234567
7891011121345678910891011121314
141516171819201112131415161715161718192021
212223242526271819202122232422232425262728
28293031252627282930312930
OCT 202412345NOV 202412DEC 20241234567
67891011123456789891011121314
131415161718191011121314151615161718192021
202122232425261718192021222322232425262728
272829303124252627282930293031
JAN 20251234FEB 20251MAR 20251
56789101123456782345678
1213141516171891011121314159101112131415
192021222324251617181920212216171819202122
26272829303123242526272823242526272829
3031
APR 202512345MAY 2025123JUN 20251234567
678910111245678910891011121314
1314151617181911121314151617151617181920*21
202122232425261819202122232422232425262728
27282930252627282930312930
First Day to Reconcile and Approve PCard Transactions
-WEDNESDAY-Last day to Reconcile and Approve pCard Transactions

-FORCE APPROVAL-

-THURSDAY- Last day to Correct Voucher Processing Errors

-TUESDAY-

First Day Transactions are available for reconciliation and approval in PeopleSoft. PLEASE NOTE: Transactions that are first available on this day are NOT included in Force approval the following day, but are included in the force approval 15 days later. Reconcilers, Approvers and Agency Adminstrators have until 5:00 PM on the Thursday after the Billing Cycle End Date to Approve PCard Transactions. State PCard Maintainer approves any remaining transactions starting at 6:00PM. Approved PCard Transactions are Built into Vouchers starting at 7:00 PM. Last Day for Agency PCard Administrators and A/P Processors to Correct PCard Voucher Pre-Edit, Recycle, and Budget Check Errors.

BILLING CYCLE START DATE BILLING CYCLE END DATE SCHEDULED BANK PAYMENT LEGAL HOLIDAY** FY25 LAST DAY TO PURCHASE

*Please Note that June 20 is the last day in the last billing cycle for FY2025.

**The State Provides nine legal holidays with pay: New Years Day (January 1), Martin Luther King Jr. Day (Third Monday in January), Memorial Day (Last Monday in May), Independence Day (July 4), Labor Day (First Monday in September) Thanksgiving(Fourth Thursday in November) Christmas Eve (December 24) Christmas Day (December 25) New Year Eve Day(December 31) Issued by: State Bureau Of Procurement (SBOP) in partnership with the State Controller's Office (SCO), in the WI Department Of Administration (DOA)

CALENDAR COLORS

FY2025 STATE PCARD BILLING CYCLE AND APPROVAL DATES
SUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISATSUNMONTUEWEDTHUFRISAT
JUL 2024123456AUG 2024123Sep 20241234567
7891011121345678910891011121314
141516171819201112131415161715161718192021
212223242526271819202122232422232425262728
28293031252627282930312930
OCT 202412345NOV 202412DEC 20241234567
67891011123456789891011121314
131415161718191011121314151615161718192021
202122232425261718192021222322232425262728
272829303124252627282930293031
JAN 20251234FEB 20251MAR 20251
56789101123456782345678
1213141516171891011121314159101112131415
192021222324251617181920212216171819202122
26272829303123242526272823242526272829
3031
APR 202512345MAY 2025123JUN 20251234567
678910111245678910891011121314
1314151617181911121314151617151617181920*21
202122232425261819202122232422232425262728
27282930252627282930312930
First Day to Reconcile and Approve PCard Transactions
-WEDNESDAY-Last day to Reconcile and Approve pCard Transactions

-FORCE APPROVAL-

-THURSDAY- Last day to Correct Voucher Processing Errors

-TUESDAY-

First Day Transactions are available for reconciliation and approval in PeopleSoft. PLEASE NOTE: Transactions that are first available on this day are NOT included in Force approval the following day, but are included in the force approval 15 days later. Reconcilers, Approvers and Agency Adminstrators have until 5:00 PM on the Thursday after the Billing Cycle End Date to Approve PCard Transactions. State PCard Maintainer approves any remaining transactions starting at 6:00PM. Approved PCard Transactions are Built into Vouchers starting at 7:00 PM. Last Day for Agency PCard Administrators and A/P Processors to Correct PCard Voucher Pre-Edit, Recycle, and Budget Check Errors.

BILLING CYCLE START DATE BILLING CYCLE END DATE SCHEDULED BANK PAYMENT LEGAL HOLIDAY** FY25 LAST DAY TO PURCHASE

*Please Note that June 20 is the last day in the last billing cycle for FY2025.

**The State Provides nine legal holidays with pay: New Years Day (January 1), Martin Luther King Jr. Day (Third Monday in January), Memorial Day (Last Monday in May), Independence Day (July 4), Labor Day (First Monday in September) Thanksgiving(Fourth Thursday in November) Christmas Eve (December 24) Christmas Day (December 25) New Year Eve Day(December 31) Issued by: State Bureau Of Procurement (SBOP) in partnership with the State Controller's Office (SCO), in the WI Department Of Administration (DOA)

SCHEDULE

PCARD RECONCILIATION KEY PROCESSES AND DATES BY INDIVIDUAL BILLING CYCLE PERIODS
This PCard Billing Cycle Chart combines information from the Process Steps and the Yearly Calendar to provide Key Event Dates and Times required to conduct a Complete and Successful PCard Reconciliation Process Cycle.
BILLING CYCLE NUMBERFIRST DAY OF BILLING CYCLE
-SATURDAY-FIRST DAY TO RECONCILE IN PEOPLESOFT
-WEDNESDAY-LAST DAY OF BILLING CYCLE
-FRIDAY-LAST DAY TO APPROVE PCARD TRANSACTIONS

FORCE APPROVAL

-THURSDAY 5:00 PM- LAST DAY TO

CORRECT PCARD VOUCHER ERRORS

-TUESDAY- SCHEDULED DATE

FOR PAYMENT TO BE

MADE TO THE BANK

-THURSDAY-

16/22/246/26/247/5/247/11/247/16/247/3/24
27/6/247/10/247/19/247/25/247/30/248/1/24
37/20/247/24/248/2/248/8/248/13/248/15/24
48/3/248/7/248/16/248/22/248/27/248/29/24
58/17/248/21/248/30/249/5/249/10/249/12/24
68/31/249/4/249/13/249/19/249/24/249/26/24
79/14/249/18/249/27/2410/3/2410/8/2410/10/24
89/28/2410/2/2410/11/2410/17/2410/22/2410/24/24
910/12/2410/16/2410/25/2410/31/2411/5/2411/7/24
1010/26/2410/30/2411/8/2411/14/2411/19/2411/21/24
1111/9/2411/13/2411/22/2411/28/2412/3/2412/5/24
1211/23/2411/27/2412/6/2412/12/2412/17/2412/19/24
1312/7/2412/11/2412/20/2412/26/2412/31/241/2/25
1412/21/2412/25/241/3/251/9/251/14/251/16/25
151/4/251/8/251/17/251/23/251/28/251/30/25
161/18/251/22/251/31/252/6/252/11/252/13/25
172/1/252/5/252/14/252/20/252/25/252/27/25
182/15/252/19/252/28/253/6/253/11/253/13/25
193/1/253/5/253/14/253/20/253/25/253/27/25
203/15/253/19/253/28/254/3/254/8/254/10/25
213/29/254/2/254/11/254/17/254/22/254/24/25
224/12/254/16/254/25/255/1/2511/27/1811/29/18
234/26/254/30/255/9/255/15/255/20/255/22/25
245/10/255/14/255/23/255/29/256/3/256/5/25
255/24/255/28/256/6/256/12/256/17/256/19/25
266/7/256/11/256/20/256/26/257/1/257/3/25
FY26 16/21/256/25/257/4/257/10/257/15/257/17/25
FY26 27/5/257/9/257/18/257/24/257/29/257/31/25

PROCESS

OVERVIEW OF PEOPLESOFT PCARD RECONCILIATION PROCESS
The Chart below provides the various Dates and Timelines that PCard proxy users will have to reconcile and approve PCard Transactions as well as correct PCard Vouchers to ensure timely payment to the Bank. This Chart's "Calendar Column and Row Colors" directly correspond with the Monthly "Calendar Dated Day Colors" which can be found on the second tab below
Day/TimeCALENDARROLESFREQUENCYREQUIREMENT ITEMS
BILLING CYCLE RECONCILIATION
SaturdayFirst Day of the billing cycle
-SATURDAY-CARDHOLDERSStartCardholders use their cards to make purchases
Starts 7:00 PM CT on the first Tuesday of the billing period and continues untilFirst PCard Transactions are imported with the status "STAGED"US BANKStartSends first PCard Statement File to be reconciled by agencies through on nightly batch cycle. Continues to send new PCard Statement Files through daily until the end of the Billing Period.
PEOPLESOFTNightSystem will load PCard Statements File batch to staging tables.
NightSystem will stage the PCard transactions and check for errors.
NightSystem will identify accurate PCard transactions and load these items to the Reconciliation Statements page with a status of "STAGED".
NightSystem has available "STAGED" PCard transactions to be reconciled.
WednesdayFirst Day to Reconcile and Approve PCard TransactionsAGENCY PCARD RECONCILERDailySearch on the Reconcile Statement Search page and enter search criteria for PCard transactions to be reconciled.
DailyCertifies chart fields, attaches receipts, and runs the Budget Validation process.
DailyUpdates chart field values to reflect a valid budget.
DailyMarks disputed transactions as "In Dispute".
DailyChecks and changes "In Dispute" transactions to "Collected" when credit is received or dispute is resolved.
DailyReconciler is responsible for tracking and resolving all disputes with Merchants.
DailyReviewed and corrected PCard transactions status will be changed from "STAGED" to "VERIFIED" on the statements page.
AGENCY PCARD APPROVERDailyReviews system "VERFIED" transactions by inspecting submitted associated transactional chart field allocations and receipts.
DailyIf "VERIFIED" transactions with corresponding chart fields and receipts are determined to be accurate, then Approver will change the transaction status from "VERIFIED" to "APPROVED".
DailyIf "VERIFIED" transactions with corresponding chart fields and receipts are determined not to be accurate, then the approver must insert an explanation into the transaction's comment section and re-set the transaction status back to "STAGED" for the Reconciler to then review and re-reconcile this transaction accordingly.
Mondays

and

ThursdaysResolve Profile ErrorsSTATE MAINTAINERWeeklyChecks for unassigned/incomplete card errors and works with Agency PCard Administrators to get these items corrected. Any cards not assigned by Agency administrators by noon on Force Approval Thursdays will be assigned by the State PCard Maintainer if they have a transaction in the current billing period. Agency Administrators should review and update the proxies and distributions for any cards added by the State PCard Maintainer at the earliest opportunity.
FridayLast Day of Billing Cycle
STATE AND BANKBi-WeeklyBilling Cycle End Date. All transactions that are received by U.S Bank within the billing cycle will have this date set as the "Bill date".
7:00 PM CT on the Sunday following the end of the billing period.Last PCard Transactions are imported with the status "STAGED"US BANKStartSends first PCard Statement File to be reconciled by agencies through on nightly batch cycle.
PEOPLESOFTNightSystem will load PCard Statements File batch to staging tables.
NightSystem will stage the PCard transactions and check for errors.
NightSystem will identify accurate PCard transactions and load these items to the Reconciliation Statements page with a status of "STAGED".
NightSystem has available "STAGED" PCard transactions to be reconciled.
Mondays following the end of the billing period.Last day for transactions in a billing cycle to appear in PeopleSoftPEOPLESOFTBi-WeeklyAll transactions to be reconciled within this billing period will be available at this time, excepting those on un-assigned or incomplete cards.
Until 5:00 PM CT Force Approval ThursdaysLast Day to Approve PCard Transactions
-FORCE APPROVAL-AGENCY PCARD APPROVERDayIdentifies all existing "STAGED" and "VERIFIED" agency transactions for the billing cycle that have not reconciled and sets these transactions to "APPROVED". All transactions not reconciled will be forced "APPROVED" so that payment to the bank will be made on time. (Urgent Situation). *Must be completed by 5:00 PM CT.
6:00 PM CT Force Approval ThursdaysSTATE MAINTAINERBi-WeeklyIdentifies all existing "STAGED" and "VERIFIED" statewide transactions for the billing cycle that have not reconciled and sets these transactions to "APPROVED". All transactions not reconciled by the Agency will be forced "APPROVED" so that all vouchers will be generated in one batch. Any transactions not approved by 7pm will fail to generate vouchers, and will have to be corrected by STAR via the submission of an error ticket.
VOUCHER BUILD PROCESS
7:00 PM CT Force Approval ThursdaysPEOPLESOFTBi-WeeklyPS System will run the Load Voucher Stage by processing the "APPROVED" PCard transactions to the voucher staging tables where transactions will be built into vouchers by card number.
Friday following Force Approval until TuesdayLast day to Correct Voucher Processing ErrorsAGENCY PCARD ADMINISTRATORDailyCorrect all Pre-Edit Errors and set transactions "TO BUILD" through the Voucher Build Error Detail page.
AGENCY AP PROCESSORDailyCorrect all voucher Recycle Errors through the Quick Invoice or voucher Regular Entry pages.
DailyResolve all Budget Check Exceptions by updating voucher distribution line(s) and/or contacting Finance to research and correct all budget issues.
7:00PM Tuesday following Force Approval and continue until Scheduled Pay Date to BankDailyPS System runs Budget Checks in a scheduled batch process multiple times throughout the day. Budget checks may also be run manually by the Agency AP Processor.
DailyPS System runs Voucher Post multiple times throughout the day.
PAYMENT TO THE BANK
ThursdayScheduled Pay Date to the BankSCODayRun Pay Cycle.

File details come from the government source that posted it. Updated .