preview

Total Accounts Receivable

Better Essays

Bradmark Wholesale
General Supply
ACL Case Study
This paper contains the summary of the details and results of the audit tests on
Bradmark’s Revenue and Expenditure Cycles. The audit tests were performed through the ACL Program.
2005
Rachelle Cultura | Trixia Ebol | Christine Fonseca
Mary Rose Samas | Nadaine Tongco
Ross & Specter Co.
October 24, 2012
1 | P a g e
REVENUE CYLCE
Assessment of Internal Controls over the Revenue Cycle
The assessment of Bradmark’s internal controls over its revenue cycle procedures were done through the analysis of the processes each department is undertaking.
For the Sales Department, it is but right that the clerk will seek the approval of the credit manager for customers
with …show more content…

After taking into account the results for these two tests, the should-be balance for the Total Sales of the period was computed to be $5,317,470.36.
Valuation or Allocation
The total Accounts Receivable balance in the records of $4,752,257.70 was verified by setting a filter of
“Remit_Num = 0” and then getting the total amount due. By doing this, only those sales which do not yet have a remittance advice are part of the accounts receivable. The figure below is the outcome of this procedure.
4 | P a g e
However, if the difference between the total sales and the total cash received (for the period ending December
31, 2004) was computed, then the total Accounts Receivable balance would be $4,578,008.14. This indicates that the Accounts Receivable is misstated in the financial statements.
Moreover, from the analyse tab and the function “Age”, an aging of the Accounts Receivable was performed.
The summary of this analysis can be seen in this figure:
5 | P a g e
It should be noted that based on this test, the allowance for doubtful accounts should be adjusted to reflect the actual accounts, which can be considered as uncollectible, i.e. those that are already over 90 days. The balance would then be $1,945,870.20.
6 | P a g e
Compared to the current estimation method of the Allowance for Doubtful Accounts of Bradmark, this method of aging the Accounts Receivable is more appropriate. This also ensures that the

Get Access