phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Audit Transactions against bank statements

  • Posted:
  • Proposals: 46
  • Remote
  • #4358313
  • Awarded
Owain W.Adnan Ali A.Oluwaseyi O.Muhammad S.Kenny K. + 41 others have already sent a proposal.
  • 4

Description

Experience Level: Intermediate
Hi there,

I need to audit an excel spreadsheet, and to check off transactions in my own records against those in bank statements. There are 927 transactions, many of which are attributed to the same company, and I’m matching these against a bank statement.

I’d like someone to perform the audit manually (i.e. not using a formula), and checking the transactions against a bank statement. I’d like to pay by the hour and I’d expect this to take someone around 4-8 hours to complete. I can go through the task in more detail once I shortlist.

Many thanks

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Aslah F.

    Hi Tom C,

    Could you please provide samples of both your internal records and your bank statement? For example, could you share a few rows of your internal records (including column titles like Date, Company, Amount) and a small sample of your bank statement (showing key columns such as Date, Description, Amount)?

    Which details should we use to match the records with the bank statement? Is it mainly the Date and Amount?

    How should we handle differences in the company name? (For example, if the company name is written slightly differently in both files, should we consider them a match?)

  • MST. SURAEA B.

    Dear Tom Chance,

    Could you please clarify if you have any specific format or method you prefer for documenting the audit, or would you like me to create a new system for tracking the matched transactions?

    Are there any specific details or red flags I should be particularly mindful of while cross-checking the transactions against the bank statement (e.g., unusual transaction amounts or discrepancies)?

    Thank you in advance , dear Tom Chance !