Manner of Submission/Transmission of the Consolidated Report of Daily Collections as well as the Preparation and Submission/Transmission of Adjustment/Supplemental Reports Thereon

June 26, 2014 BANK BULLETIN NO. 14-14 TO : All BIR Authorized Agent Banks SUBJECT : Manner of Submission/Transmission of the Consolidated Report of Daily Collections as well as the Preparation and Submission/Transmission of Adjustment/Supplemental Reports Thereon Since the implementation of the electronic submission (e-Submission) of the Consolidated Report of Daily Collections (eCRDC) in 2010, problems still exist regarding the uploading/non-uploading of CRDC data files to the Bureau of Internal Revenue's (BIR) Integrated Tax System (ITS) due to codes or data errors detected by the system. Relative thereto, and in order to properly and timely capture all the details of the collection reports, all AABs are hereby advised of the following policies and guidelines in the manner of submission/transmission of the eCRDC as well as preparation and submission/transmission of the corresponding Amended/Supplemental reports: 1. The transmission of the eCRDC shall be within five (5) days after collection date; and if the due date for the submission of the said report falls on a Saturday, Sunday or Holiday, the transmission of the report should be immediately on the next working day following the non-working day (Bank Bulletin No. 2014-03). However, with the implementation of the Treasury Single Account (TSA) beginning January 2, 2014, the deadline for the electronic submission of the daily CRDC for both Electronic Filing and Payment System (eFPS) and Over-the-Counter (OTC) transactions falls on the same date. In order to avoid occurrence of any error in the uploading of the collection data to the ITS-Collection and Bank Reconciliation System (CBRS) in cases where the concerned AABs have both OTC and electronic payment transactions on the same day, the CRDC for eFPS transactions and online tax payments thru the Bureau of Internal Revenue's Interactive Forms System (IAFS) shall be submitted first not later than 5:00 PM of the prescribed due date. Thereafter, the transmission of CRDC for OTC transactions shall be made after 5:00 PM of the said due date. However, in case tax collections for any given day was made only either thru OTC transactions or eFPS/IAFS transactions, the daily eCRDC shall be submitted anytime of the day within five (5) days reckoned from collection date. aDSIHc Illustrative example: Channel of Payment Collection Date Computed Due Date Due Date for e-Submission Transmission Time 1. For daily collections with both eFPS/IAFS and OTC Transactions: a. eFPS/IAFS May 13, 2014 (Tuesday) May 18, 2014 (Sunday) May 19, 2014 (Monday) 8:00 AM-5:00 PM b. OTC May 13, 2014 (Tuesday) May 18, 2014 (Sunday) May 19, 2014 (Monday) 5:01 PM-11:59 PM 2. For daily collections with OTC or eFPS/IAFS Transactions only: a. OTC May 13, 2014 (Tuesday) May 18, 2014 (Sunday) May 19, 2014 (Monday) Within the day (8:00 AM-11:59 PM) 2. In case of error/s, including over-reporting/remittance and under reporting/remittance, was/were discovered on the day of submission and the AAB opted to correct/revise the CRDC within the same day, the transmission of said revised/corrected CRDC shall be made in the following manner: a. For daily collections with both eFPS/IAFS and OTC Transactions The electronic transactions must be submitted not later than 5:00 PM of the same day and not earlier than 5:01 PM for OTC transactions, also of the same day. There shall be no limit in the resubmission of the corrected CRDC provided that it is transmitted within the above-prescribed transmission time. b. For daily collections with only OTC or eFPS/IAFS Transactions The corrected/revised CRDC can be submitted anytime without any restriction on the 5:00 PM cut-off time. 3. In case there is a need to adjust a previously submitted CRDC for eFPS/IAFS transactions, OTC transactions, or both after the original transmission date, the policies and procedures listed below shall be followed: a. If the error is due to over-reporting/remittance The concerned AAB shall send the hardcopy of the CRDC together with the List of Adjustments (sample format below) to the Revenue Accounting Division (RAD) to enable the said division to manually modify/adjust the data in the ITS. There is no need for the AAB to transmit the adjusted CRDC through the eCRDC facility. Otherwise, there will be double/multiple posting of collection data in the BIR-ITS. Sample Format: List of Adjustments: Branch RDO Collection Amount Correct Over- Code/ Code Date Reported Amount of remittance of Name thru Collection Collection eCRDC 002- 039 5/3/14 17,400.00 17,050.00 (350.00) 670- Capitol Hills Total 17,400.00 17,050.00 (350.00) ======== ======== ======== b. If the error is due to under-reporting/remittance The AAB shall submit a supplemental report indicating only the bank branch/es and corresponding amount/s that need to be added. There is no need to include the previously reported collection data from the AAB branch/es without error/s. Furthermore, the word "SUPPLEMENTAL" shall be indicated opposite the affected collection date. Example: If the actual amount of collection by AAB Branch with bank code 086-086 on April 23, 2014 is P1,102.00 but the amount of collection reported in the CRDC was only P1,000.00, or an under-remittance of P102.00, the said adjustment to the CRDC should be reported to the Revenue Accounting Division (RAD) as follows: ETHIDa April 23, 2014-SUPPLEMENTAL Date of Collection A. ACCUMULATED TOTAL COLLECTION FROM THE LATEST REPORT SUBMITTED P12,221,962.00 B. AMOUNT OF UNREPORTED/UNREMITTED COLLECTION 102.00 BANK HEAD RDO BCS AMOUNT REMARKS CODE OFFICE/ CODE NUMBER CASH BRANCH 086-086 SAN 104 A-20111 102.00 FRANCISCO ADS Sub-total 102.00 ====== Total Amount of Unreported/Unremitted Collection for the Day 102.00 C. ACCUMULATED TOTAL AS OF TODAY 12,222,064.00 4. In the transmission of the eCRDC, including the Supplemental eCRDC, the AAB-Head Office shall follow the hereunder csv filename format: Collection Date-April 23, 2014, OTC Original Report : 086042314CRDC01R.csv Supplemental Report : 086042314CRDC51R.csv Where: 086 - Shall refer to the first 3 digits of the AAB-Head Office's Bank Code 042314 - Shall refer to the collection date 04 for the collection month (01-12); 23 for the day of collection (01 to 31); and 14 for the last 2 digits of the year of collection CRDC - Constant 01 - Shall refer to the version 01 Original Version (01 to 50) 51 for the Supplemental Report (51 to 99) R - Shall refer to the Payment Channel R-Regular Payment Channels (e.g., LBDES, ESM, GCASH); or E - eFPS and IAFS 5. The Supplemental CRDC shall be e-mailed to [emailprotected] in accordance with the provisions of Bank Bulletin No. 2010-27. The reason for the submission of the supplemental report shall be indicated in the separate e-mail letter of the AAB-Head Office to [emailprotected] for the purpose of determining the appropriate action to be taken by the BIR. TIADCc 6. In case there is no collection on the given day, the AAB-Head Office shall still prepare the eCRDC stating therein that there was no tax payment received on such specified day and e-mail the same to [emailprotected]. This Bank Bulletin shall take effect for tax collections made beginning July 1, 2014 and shall be in effect until revoked by another Bank Bulletin. For your information and guidance. (SGD.) KIM S. JACINTO-HENARES Commissioner of Internal Revenue