0% found this document useful (0 votes)
12 views5 pages

Accounts Receivable Summary 2018

This document shows accounting transactions between May 17, 2018 and various Catholic schools and parishes. It lists invoices issued and payments received on various dates for each school/parish. The ending balances for each school/parish are also shown. In total, there are invoices for over $500,000 issued to 27 schools/parishes and payments of over $300,000 received from 14 of them, leaving a remaining balance owed of over $200,000.

Uploaded by

Beth Sai
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
12 views5 pages

Accounts Receivable Summary 2018

This document shows accounting transactions between May 17, 2018 and various Catholic schools and parishes. It lists invoices issued and payments received on various dates for each school/parish. The ending balances for each school/parish are also shown. In total, there are invoices for over $500,000 issued to 27 schools/parishes and payments of over $300,000 received from 14 of them, leaving a remaining balance owed of over $200,000.

Uploaded by

Beth Sai
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

9:24 AM Bishop's Installation

05/17/18
All Transactions

Type Date Num Account Class Amount Balance


Binalbagan Catholic College
Payment 05/08/2018 16427 Accounts Receivable -50,000.00 -50,000.00
Invoice 05/10/2018 29 Accounts Receivable 50,000.00 0.00

Total Binalbagan Catholic College 0.00 0.00

Cabarrus Catholic College


Payment 04/16/2018 16271 Accounts Receivable -30,000.00 -30,000.00
Invoice 05/10/2018 30 Accounts Receivable 30,000.00 0.00

Total Cabarrus Catholic College 0.00 0.00

Christ the King Parish - Magballo


Invoice 05/10/2018 18 Accounts Receivable 20,000.00 20,000.00
Payment 05/16/2018 16526 Accounts Receivable -800.00 19,200.00
Payment 05/16/2018 16532 Accounts Receivable -13,000.00 6,200.00

Total Christ the King Parish - Magballo 6,200.00 6,200.00

Holy Rosary Academy


Invoice 05/10/2018 45 Accounts Receivable 10,000.00 10,000.00
Payment 05/11/2018 16482 Accounts Receivable -10,000.00 0.00

Total Holy Rosary Academy 0.00 0.00

Holy Rosary Parish - Aguisan


Invoice 04/06/2018 7 Accounts Receivable 40,000.00 40,000.00
Payment 05/15/2018 16509 Accounts Receivable -25,560.60 14,439.40

Total Holy Rosary Parish - Aguisan 14,439.40 14,439.40

Ilog Catholic High School


Invoice 05/10/2018 43 Accounts Receivable 10,000.00 10,000.00

Total Ilog Catholic High School 10,000.00 10,000.00

Immaculate Conception Academy


Invoice 05/10/2018 32 Accounts Receivable 10,000.00 10,000.00

Total Immaculate Conception Academy 10,000.00 10,000.00

Immaculate Conception Parish - Dancalan


Payment 05/09/2018 16433 Accounts Receivable -16,000.00 -16,000.00
Invoice 05/10/2018 16 Accounts Receivable 20,000.00 4,000.00

Total Immaculate Conception Parish - Dancalan 4,000.00 4,000.00

Kabankalan Catholic College


Invoice 05/10/2018 28 Accounts Receivable 100,000.00 100,000.00
Payment 05/15/2018 16500 Accounts Receivable -100,000.00 0.00

Total Kabankalan Catholic College 0.00 0.00

Magballo Catholic High School


Payment 04/24/2018 16321 Accounts Receivable -15,000.00 -15,000.00
Invoice 05/10/2018 41 Accounts Receivable 15,000.00 0.00

Total Magballo Catholic High School 0.00 0.00

Page 1
9:24 AM Bishop's Installation
05/17/18
All Transactions

Type Date Num Account Class Amount Balance


Nuestra Señora de las Nieves
Invoice 05/10/2018 40 Accounts Receivable 10,000.00 10,000.00

Total Nuestra Señora de las Nieves 10,000.00 10,000.00

Our Lady of Candles Chaplaincy - Oringao


Invoice 05/10/2018 21 Accounts Receivable 15,000.00 15,000.00

Total Our Lady of Candles Chaplaincy - Oringao 15,000.00 15,000.00

Our Lady of Candles Parish - Culipapa


Invoice 05/10/2018 20 Accounts Receivable 15,000.00 15,000.00

Total Our Lady of Candles Parish - Culipapa 15,000.00 15,000.00

Our Lady of Lourdes High School


Invoice 05/10/2018 37 Accounts Receivable 10,000.00 10,000.00

Total Our Lady of Lourdes High School 10,000.00 10,000.00

Our Lady of Lourdes Parish - Candoni


Payment 05/07/2018 16380 Accounts Receivable -30,000.00 -30,000.00
Invoice 05/10/2018 13 Accounts Receivable 30,000.00 0.00

Total Our Lady of Lourdes Parish - Candoni 0.00 0.00

Our Lady of Salvation Parish - Cabacungan


Invoice 05/10/2018 19 Accounts Receivable 20,000.00 20,000.00
Payment 05/16/2018 16519 Accounts Receivable -10,000.00 10,000.00

Total Our Lady of Salvation Parish - Cabacungan 10,000.00 10,000.00

Our Lady of Snows Parish - Himamaylan


Invoice 04/06/2018 4 Accounts Receivable 50,000.00 50,000.00
Payment 05/08/2018 16415 Accounts Receivable -12,700.00 37,300.00

Total Our Lady of Snows Parish - Himamaylan 37,300.00 37,300.00

Our Lady of Sorrows Academy


Invoice 05/10/2018 44 Accounts Receivable 10,000.00 10,000.00

Total Our Lady of Sorrows Academy 10,000.00 10,000.00

Sacred Heart of Jesus Parish - Sipalay


Invoice 04/06/2018 9 Accounts Receivable 40,000.00 40,000.00
Payment 04/30/2018 16345 Accounts Receivable -40,000.00 0.00

Total Sacred Heart of Jesus Parish - Sipalay 0.00 0.00

San Blas Academy


Invoice 05/10/2018 39 Accounts Receivable 10,000.00 10,000.00

Total San Blas Academy 10,000.00 10,000.00

San Blas Parish - Payao


Invoice 05/10/2018 14 Accounts Receivable 30,000.00 30,000.00

Total San Blas Parish - Payao 30,000.00 30,000.00

Page 2
9:24 AM Bishop's Installation
05/17/18
All Transactions

Type Date Num Account Class Amount Balance


San Isidro Academy
Invoice 05/10/2018 35 Accounts Receivable 10,000.00 10,000.00

Total San Isidro Academy 10,000.00 10,000.00

San Isidro Parish - Magallon


Invoice 05/10/2018 11 Accounts Receivable 40,000.00 40,000.00

Total San Isidro Parish - Magallon 40,000.00 40,000.00

San Isidro Parish - Salong


Invoice 05/10/2018 26 Accounts Receivable 15,000.00 15,000.00

Total San Isidro Parish - Salong 15,000.00 15,000.00

San Lorenzo Ruiz Chap. - Tapi


Payment 04/30/2018 16347 Accounts Receivable -19,570.00 -19,570.00
Invoice 05/10/2018 27 Accounts Receivable 25,455.00 5,885.00
Payment 05/15/2018 16511 Accounts Receivable -5,885.00 0.00

Total San Lorenzo Ruiz Chap. - Tapi 0.00 0.00

San Nicolas de Tolentino Parish - Isabela


Invoice 04/06/2018 5 Accounts Receivable 50,000.00 50,000.00
Payment 05/16/2018 16523 Accounts Receivable -50,000.00 0.00

Total San Nicolas de Tolentino Parish - Isabela 0.00 0.00

San Ramon Catholic School


Invoice 05/10/2018 36 Accounts Receivable 10,000.00 10,000.00

Total San Ramon Catholic School 10,000.00 10,000.00

San Ramon Nonato Parish - Su-ay


Invoice 04/06/2018 1 Accounts Receivable 15,000.00 15,000.00
Payment 04/06/2018 12860 Accounts Receivable -10,000.00 5,000.00

Total San Ramon Nonato Parish - Su-ay 5,000.00 5,000.00

St. Columban's Academy


Invoice 05/10/2018 31 Accounts Receivable 10,000.00 10,000.00

Total St. Columban's Academy 10,000.00 10,000.00

St. Francis Borgia Parish - Isio


Payment 04/06/2018 12868 Accounts Receivable -1,000.00 -1,000.00
Invoice 05/10/2018 17 Accounts Receivable 20,000.00 19,000.00

Total St. Francis Borgia Parish - Isio 19,000.00 19,000.00

Page 3
9:24 AM Bishop's Installation
05/17/18
All Transactions

Type Date Num Account Class Amount Balance


St. Francis Xavier Parish - Kabankalan
Invoice 04/06/2018 2 Accounts Receivable 62,920.00 62,920.00
Payment 04/12/2018 12971 Accounts Receivable -1,000.00 61,920.00
Payment 04/25/2018 16324 Accounts Receivable -2,000.00 59,920.00
Payment 04/25/2018 16325 Accounts Receivable -2,000.00 57,920.00
Payment 04/25/2018 16326 Accounts Receivable -1,700.00 56,220.00
Payment 04/25/2018 16327 Accounts Receivable -2,000.00 54,220.00
Payment 05/10/2018 16474 Accounts Receivable -2,000.00 52,220.00
Payment 05/16/2018 16515 Accounts Receivable -52,220.00 0.00

Total St. Francis Xavier Parish - Kabankalan 0.00 0.00

St. Isidore Parish - Binalbagan


Invoice 04/06/2018 3 Accounts Receivable 50,000.00 50,000.00
Payment 05/02/2018 16360 Accounts Receivable -25,000.00 25,000.00

Total St. Isidore Parish - Binalbagan 25,000.00 25,000.00

St. John the Baptist Chaplaincy - Sonedco


Invoice 05/10/2018 25 Accounts Receivable 15,000.00 15,000.00
Payment 05/15/2018 16503 Accounts Receivable -4,000.00 11,000.00

Total St. John the Baptist Chaplaincy - Sonedco 11,000.00 11,000.00

St. John the Baptist Parish - Ilog


Invoice 05/10/2018 22 Accounts Receivable 22,525.00 22,525.00
Payment 05/11/2018 16475 Accounts Receivable -6,825.00 15,700.00
Payment 05/15/2018 16512 Accounts Receivable -700.00 15,000.00

Total St. John the Baptist Parish - Ilog 15,000.00 15,000.00

St. Joseph H. of Mary Chap. - Tabugon


Payment 05/07/2018 16404 Accounts Receivable -8,399.00 -8,399.00
Invoice 05/10/2018 24 Accounts Receivable 15,000.00 6,601.00
Payment 05/16/2018 16517 Accounts Receivable -6,601.00 0.00

Total St. Joseph H. of Mary Chap. - Tabugon 0.00 0.00

St. Joseph H. of Mary Parish - Inayauan


Invoice 05/10/2018 15 Accounts Receivable 20,000.00 20,000.00

Total St. Joseph H. of Mary Parish - Inayauan 20,000.00 20,000.00

St. Joseph High School


Payment 04/23/2018 16318 Accounts Receivable -10,000.00 -10,000.00
Invoice 05/10/2018 42 Accounts Receivable 10,000.00 0.00

Total St. Joseph High School 0.00 0.00

St. Joseph the Worker Chaplaincy - Mina


Invoice 05/10/2018 12 Accounts Receivable 30,000.00 30,000.00

Total St. Joseph the Worker Chaplaincy - Mina 30,000.00 30,000.00

St. Michael Academy


Invoice 05/10/2018 33 Accounts Receivable 10,000.00 10,000.00

Total St. Michael Academy 10,000.00 10,000.00

Page 4
9:24 AM Bishop's Installation
05/17/18
All Transactions

Type Date Num Account Class Amount Balance


St. Michael Archangel Parish - Hinoba-an
Invoice 04/06/2018 10 Accounts Receivable 40,000.00 40,000.00

Total St. Michael Archangel Parish - Hinoba-an 40,000.00 40,000.00

St. Paul Parish - Cauayan


Invoice 04/06/2018 8 Accounts Receivable 40,000.00 40,000.00
Payment 05/08/2018 16424 Accounts Receivable -17,263.00 22,737.00

Total St. Paul Parish - Cauayan 22,737.00 22,737.00

St. Vincent's High School


Invoice 05/10/2018 38 Accounts Receivable 10,000.00 10,000.00

Total St. Vincent's High School 10,000.00 10,000.00

St. Vincent Ferrer Chaplaincy - Binicuil


Invoice 05/10/2018 23 Accounts Receivable 15,000.00 15,000.00
Payment 05/16/2018 16516 Accounts Receivable -15,000.00 0.00

Total St. Vincent Ferrer Chaplaincy - Binicuil 0.00 0.00

St. Vincent Ferrer Parish - La Castellana


Invoice 04/06/2018 6 Accounts Receivable 150,000.00 150,000.00
Payment 04/10/2018 12928 Accounts Receivable -100,000.00 50,000.00
Payment 05/10/2018 16457 Accounts Receivable -14,040.00 35,960.00

Total St. Vincent Ferrer Parish - La Castellana 35,960.00 35,960.00

Stella Maris Academy


Invoice 05/10/2018 34 Accounts Receivable 10,000.00 10,000.00
Payment 05/15/2018 16510 Accounts Receivable -10,000.00 0.00

Total Stella Maris Academy 0.00 0.00

TOTAL 520,636.40 520,636.40

Page 5

Common questions

Powered by AI

The financial transactions reveal that schools such as Immaculate Conception Academy, Our Lady of Sorrows Academy, and others consistently maintained a balance cut-off at the invoice settled amount (10,000.00 each). Parishes, however, like Our Lady of Snows Parish - Himamaylan and St. Michael Archangel Parish - Hinoba-an often retained higher outstanding balances post-payment, suggesting differences in revenue cycle, dependence on external financial influx (e.g., donations), or prioritization in financial planning. Discrepancies between educational institutions' disciplined advances versus parishes' conscientious deferrals highlight their respective financing and operational objectives, adding depth to maintenance choices.

San Isidro Parish - Magallon and St. Michael Archangel Parish - Hinoba-an both have relatively high remaining balances, each at 40,000.00 . These balances signify that although invoices were issued and expected payments occurred, full payments were not received by the due date. For San Isidro, no payment was recorded, while for St. Michael, the invoice issued on 04/06/2018 has not been followed by any payment, suggesting potential cash flow issues or delays in payment processing within these institutions.

Institutions such as Holy Rosary Academy and Kabankalan Catholic College demonstrate effective financial management by achieving a zero balance through prompt payments matching their invoiced amounts. Holy Rosary Academy settled a 10,000.00 invoice immediately on 05/11/2018, a day after its issuance, while Kabankalan cleared a 100,000.00 invoice within five days. Such efficiency could be attributed to disciplined budget management, availability of funds, and prioritization of accounts receivable management .

The pattern observed shows that invoices are often issued on or around May 10, 2018, for a range of different Catholic institutions. Payments, however, do not follow a uniform pattern in terms of timing. For instance, some payments precede the invoice dates, such as the Immaculate Conception Parish - Dancalan, which has a payment on May 9, 2018. Other payments occur shortly after the invoice is issued, like the Holy Rosary Academy which has a payment on May 11, 2018, immediately following its invoice on May 10, 2018 .

The observed pattern of simultaneous invoicing on May 10, 2018, across multiple institutions suggests a coordinated effort possibly due to shared administrative practices or centralized financial oversight. Analyzing varied payment responses, institutions such as those maintaining zero balances demonstrate favorable cash flow management, potentially indicative of strategic reserve allocations. In contrast, high unpaid balances in others might signal operational challenges or irregular incoming funds. Therefore, similar organizations can leverage timely invoicing coupled with versatile payment schedules to enhance liquidity and financial stability .

Magballo Catholic High School achieved account balance neutrality by matching a payment on 04/24/2018 of -15,000.00 exactly with an invoice of 15,000.00 issued on 05/10/2018, resulting in a zero balance . This suggests a strategic approach to maintain their account in balance by ensuring that payments are aligned with their receivables, indicating a proactive stance in managing their finances.

Parishes like St. Vincent Ferrer Parish - La Castellana, with significant residual balances like 35,960.00, likely struggle with sporadic cash flows due to their dependence on donations, which can be unpredictable compared to tuition or service fee-based income of schools such as Stella Maris Academy that achieve a zero balance swiftly . The tendency to have balance carry-overs in parishes may reflect variable financial inflows and potentially unplanned expenses, posing challenges in cash flow management and necessitating adaptable financial strategies to ensure operational continuity and service provision.

St. Vincent Ferrer Parish - La Castellana demonstrates a pattern of staggered payments after receiving a high-value invoice. Initially, a 150,000.00 invoice was issued on 04/06/2018. Payments followed in installments of -100,000.00 on 04/10/2018 and -14,040.00 on 05/10/2018, leaving a remaining balance of 35,960.00 . This indicates a behavior of partial settlement towards reaching the total invoice amount, possibly due to budgeting or cash flow considerations.

For Binalbagan Catholic College, the transactions result in a net balance of 0.00 as the payment of -50,000.00 on 05/08/2018 is completely offset by an invoice of 50,000.00 on 05/10/2018 . Conversely, Christ the King Parish - Magballo ends up with a positive balance of 6,200.00 after receiving a 20,000.00 invoice on 05/10/2018 and subsequent payments reducing the accounts receivable by -800.00 and -13,000.00 on 05/16/2018 . This indicates that while Binalbagan reached a zero balance, Christ the King Parish retained a significant outstanding balance.

St. Joseph H. of Mary Chaplaincy - Tabugon showed a method of managing its payable balances through incremental payments. After an initial payment on 05/07/2018 of -8,399.00, followed by another clearing payment on 05/16/2018 of -6,601.00, the account balance was brought to zero following a 15,000.00 invoice on 05/10/2018 . This reflects a structured clearing of liabilities that may indicate planning for similar methods in its associated institutions. Such structured settlements suggest an overarching disciplined financial strategy that reinforces fiscal stability amongst related entities.

You might also like