Scribd Logo
Upload

Welcome to Scribd!

  • 152 views

    Alfamart CMR For ACR2225 - KAS Validation

    Uploaded by

    Jonathan Doctolero
    This document provides an aged accounts receivables report for Pioneer Adhesives, Inc. showing customer account balances as of September 26, 2022. It lists Alfamart Trading Philippines as owing $1,179,281.49 total across three invoices for consignment sales in September 2022. The document also includes a request for a $33,771.38 credit memo for Alfamart to be charged to the sales department.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Alfamart CMR For ACR2225 - KAS Validation

    Uploaded by

    Jonathan Doctolero
    152 views5 pages
    This document provides an aged accounts receivables report for Pioneer Adhesives, Inc. showing customer account balances as of September 26, 2022. It lists Alfamart Trading Philippines as owing $1,179,281.49 total across three invoices for consignment sales in September 2022. The document also includes a request for a $33,771.38 credit memo for Alfamart to be charged to the sales department.

    Original Title

    Alfamart CMR for ACR2225_KAS Validation

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an aged accounts receivables report for Pioneer Adhesives, Inc. showing customer account balances as of September 26, 2022. It lists Alfamart Trading Philippines as owing $1,179,281.49 total across three invoices for consignment sales in September 2022. The document also includes a request for a $33,771.38 credit memo for Alfamart to be charged to the sales department.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    152 views5 pages

    Alfamart CMR For ACR2225 - KAS Validation

    Uploaded by

    Jonathan Doctolero
    This document provides an aged accounts receivables report for Pioneer Adhesives, Inc. showing customer account balances as of September 26, 2022. It lists Alfamart Trading Philippines as owing $1,179,281.49 total across three invoices for consignment sales in September 2022. The document also includes a request for a $33,771.38 credit memo for Alfamart to be charged to the sales department.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    641211657.

    xlsx Date: 01/27/2023Time: 14:05:40Page: 1 of 5

    PIONEER ADHESIVES, INC.


    Aged Accounts Receivables
    Customer Account Balances

    Company PIONEER ADHESIVES, INC.


    Date Filter 09/26/2022

    Customer Code GOC Salesman Sales Area Department Sales Channel Channel Area Due Date Document Date
    FY COVERAGE/ PERIODPayment Terms Description Document Type Document No. External Document No. Amount Balance Due
    100969 ALFAMART TRADING PHILIPPINE
    DOCTOLERO, JONATHAN MT 00-00-0000-SL-DD-PMT-MHC-000-000 MT MT MT 11/13/2022 09/14/2022 12-2022 60D CONSIGNMENT SALES FTM OF SEPTEMBER 2022 Invoice SPI0000305132 ALFAMART SILANG AUGUST 2022 SALES REP 208,145.16 208,145.16 For countering
    100969 ALFAMART TRADING PHILIPPINE
    DOCTOLERO, JONATHAN MT 00-00-0000-SL-DD-PMT-MHC-000-000 MT MT MT 11/13/2022 09/14/2022 12-2022 60D CONSIGNMENT SALES FTM OF SEPTEMBER 2022 Invoice SPI0000305133 ALFAMART PAMPANGA AUGUST 2022 SALES 156,277.44 156,277.44 For countering
    100969 ALFAMART TRADING PHILIPPINE
    DOCTOLERO, JONATHAN MT 00-00-0000-SL-DD-PMT-MHC-000-000 MT MT MT 11/13/2022 09/14/2022 12-2022 60D CONSIGNMENT SALES FTM OF SEPTEMBER 2022 Invoice SPI0000305134 ALFAMART MARILAO AUGUST 2022 SALES R 76,181.40 76,181.40 For countering
    REPORT TOTAL 1,179,281.49
    AGE PERCENTAGE TO TOTAL

    Created by: <<USER>>, Jet Reports <<DATE>> 1


    Document Final CM Invoice Sales Report
    Document # Date SOA Reference Description Period Amount Amount Diff ACR# Date Invoice # Inv. Amt. Amt.
    10/10/2022 1000101350 PA#27173 8th Anniv. Sup. Sep-22 11,200.00 11,200.00 - 2225 09/14/2022 305132 208,145.16 208,145.31
    9/30/2022 1000101199 VPS_SEPT 2022 Sep-22 1,074.83 1,074.83 - 2225 09/14/2022 305133 156,277.44 156,277.62
    9/30/2022 1000101009 LSA DC SIL_SEP 2022 Sep-22 10,109.98 10,109.98 - 2225 09/14/2022 305134 76,181.40 76,181.55
    9/30/2022 1000100817 LSA DC MEX_SEP 2022 Sep-22 7,942.09 7,942.09 -
    1
    9/30/2022 1000100630 LSA DC MAR_SEP 2022 Sep-22 3,444.48 3,444.48 -
    - -
    EWT 3,933.97 3933.968571
    Total ANP 37,705.35 33,771.38 3,933.97 440,604.00 440,604.48
    KAS VALIDATION

    Check Amt. Deductions TTA Basis Amount Computation Difference

    PA#27173 8th Anniv. Sup. 10,000 Aniv Support Ex Vat from TTA 10,000.00 11,200.00 -
    VPS_SEPT 2022 Portal Fee-0.25% of Invoiced Sales Total September 2022 Sales Report 429,931.08 1,074.83 - 0.002
    LSA DC SIL_SEP 2022 DC Fee -5% of Invoiced Sales Silang DC September 2022 Sales Report 202,199.64 10,109.98 0.002
    LSA DC MEX_SEP 2022 DC Fee -5% of Invoiced Sales Mexico DC September 2022 Sales Report 158,841.80 7,942.09 -
    LSA DC MAR_SEP 2022 DC Fee -5% of Invoiced Sales Marilao DC September 2022 Sales Report 68,889.64 3,444.48 0.002
    EWT 1% Net of Vat Actual Sales Report Value Invoiced for the month 440,604.48 3,933.97 -
    Total Diff 0.002
    402,899.13

    2022 TTA
    Remarks

    10,000 Plus 12% Vat


    Actual September Sales Report basis
    Actual September Sales Report basis
    Actual September Sales Report basis
    Actual September Sales Report basis
    Basis is always Sales Report Value
    REQUEST FOR CREDIT MEMO
    Account No. 100969 Date Filed 6/11/2022
    Account Name ALFAMART TRADING PHILIPPINES INC. Department SALES-MT-CV
    PWP Reference No./
    Payment Term
    Budget Code
    Currency PHP CM for

    BSF
    Transaction Details
    Page Reference Document Department to be
    Transaction Date Number Number Amount GL Account Charged Transaction Description
    October 2022 1 Alfamart CM Reference 33,771.38 430060 Trade Business Support Fees SALES-MT-CV Alfamart Collection ACR

    TOTAL 33,771.38

    Prepared by: Approved by:

    Jonathan Doctolero Walter Gaffud


    Employee/Department Admin Assistant Department Head/VP

    Reviewed by:

    Mylaine Gonzales/ Joyce Dizon


    Immediate Superior/Line Manager/TMG EVP and General Manager

    For Advertising and Promotion Expense/CM

    Checked by: Approved by:

    Financial Analyst FP&A Manager

    AR / General Accounting Department Processing

    Processed by: Approved by:

    AR Analyst General Acctg Manager

    Treasury Department Processing

    Processed by: Received by:

    Treasury Analyst Signature Over Printed Name & Date

    Note: Print in 2 copies; 1) Requestor's Copy 2) CM Attachment

    You might also like