Homework Help is Here – Start Your Trial Now!
Business
Accounting
Type Details Particulars Code Reference Amount Date ForeignCurrencyAmount ConversionCharge Food supplier GF fundraising 1/04/21 3/04/21 5/04/21 5/04/21 6/04/21 6/04/21 7/04/21 7/04/21 8/04/21 8/04/21 8/04/21 9/04/21 10/04/21 11/04/21 13/04/21 14/04/21 17/04/21 19/04/21 19/04/21 19/04/21 19/04/21 20/04/21 20/04/21 23/04/21 23/04/21 24/04/21 25/04/21 25/04/21 26/04/21 29/04/21 Payment Transfer 4017 -343 1800 Direct Credit GF donation 20 Payment Petrol -68 Payment Financial support provided -230 Payment Venue hire 1878 -172.5 Direct Credit GF donation 50 Payment 4019 Food supplier Financial support provided Financial support provided Food supplier -490 Payment -280 Payment -120 Payment 4020 -378 Payment Financial support provided -550 Direct Credit GF donation 20 Payment Payment Rent 860 -500 Office supply store 2425 -75.5 Direct Debit Telecom Ltd 1513686050 -60 Direct Credit GF donation 10 Payment Financial support provided -75 Direct Credit Grant received 1000 Payment Venue hire 1881 -172.5 Payment Food supplier 4025 -305 Direct Credit GF donation 100 Payment Repairs & Maintenance Direct Credit Bequest - James Secretan Food supplier Food supplier 448 -350 2000 Payment 4028 -259 Payment 4029 473 Direct Credit GF donation 20 Payment Petrol -43 Payment Petrol 97 Direct Debit Energy and Gas Ltd 2517548234 -62

Type Details Particulars Code Reference Amount Date ForeignCurrencyAmount ConversionCharge Food supplier GF fundraising 1/04/21 3/04/21 5/04/21 5/04/21 6/04/21 6/04/21 7/04/21 7/04/21 8/04/21 8/04/21 8/04/21 9/04/21 10/04/21 11/04/21 13/04/21 14/04/21 17/04/21 19/04/21 19/04/21 19/04/21 19/04/21 20/04/21 20/04/21 23/04/21 23/04/21 24/04/21 25/04/21 25/04/21 26/04/21 29/04/21 Payment Transfer 4017 -343 1800 Direct Credit GF donation 20 Payment Petrol -68 Payment Financial support provided -230 Payment Venue hire 1878 -172.5 Direct Credit GF donation 50 Payment 4019 Food supplier Financial support provided Financial support provided Food supplier -490 Payment -280 Payment -120 Payment 4020 -378 Payment Financial support provided -550 Direct Credit GF donation 20 Payment Payment Rent 860 -500 Office supply store 2425 -75.5 Direct Debit Telecom Ltd 1513686050 -60 Direct Credit GF donation 10 Payment Financial support provided -75 Direct Credit Grant received 1000 Payment Venue hire 1881 -172.5 Payment Food supplier 4025 -305 Direct Credit GF donation 100 Payment Repairs & Maintenance Direct Credit Bequest - James Secretan Food supplier Food supplier 448 -350 2000 Payment 4028 -259 Payment 4029 473 Direct Credit GF donation 20 Payment Petrol -43 Payment Petrol 97 Direct Debit Energy and Gas Ltd 2517548234 -62

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

Use the VLOOKUP function to create one formula that can identify discrepancies between the invoice list and the bank statement.

Date Amount Purchase order Invoice Description Paid Recocnile 1/04/21 5/04/21 6/04/21 7/04/21 11/04/21 13/04/21 13/04/21 343 5839 4017 Food Yes 172.5 1878 Venue hire Yes 490 5840 4019 Food Yes 378 5841 4020 Food Yes 500 860 Rent Yes 75.5 5842 2425 Office supply Yes 60 1513686050 Landline and mobile Yes 19/04/21 19/04/21 20/04/21 22/04/21 23/04/21 29/04/21 30/04/21 127.5 1881 Venue hire Yes 350 5843 4025 Food Yes 350 448 Repairs Yes 259 5844 4028 Food Yes 473 5845 4029 Food Yes 62 2517548234 Electricity Yes 165 5846 4035 Food Yes
Transcribed Image Text:Date Amount Purchase order Invoice Description Paid Recocnile 1/04/21 5/04/21 6/04/21 7/04/21 11/04/21 13/04/21 13/04/21 343 5839 4017 Food Yes 172.5 1878 Venue hire Yes 490 5840 4019 Food Yes 378 5841 4020 Food Yes 500 860 Rent Yes 75.5 5842 2425 Office supply Yes 60 1513686050 Landline and mobile Yes 19/04/21 19/04/21 20/04/21 22/04/21 23/04/21 29/04/21 30/04/21 127.5 1881 Venue hire Yes 350 5843 4025 Food Yes 350 448 Repairs Yes 259 5844 4028 Food Yes 473 5845 4029 Food Yes 62 2517548234 Electricity Yes 165 5846 4035 Food Yes
Туре Details Particulars Code Reference Amount Date ForeignCurrencyAmount ConversionCharge Food supplier 1/04/21 3/04/21 5/04/21 5/04/21 6/04/21 6/04/21 7/04/21 7/04/21 8/04/21 8/04/21 8/04/21 9/04/21 10/04/21 11/04/21 13/04/21 14/04/21 17/04/21 19/04/21 19/04/21 19/04/21 Payment 4017 -343 Transfer GF fundraising 1800 Direct Credit GF donation 20 Payment Petrol -68 Payment Financial support provided -230 Payment Venue hire 1878 -172.5 Direct Credit GF donation 50 Payment Payment Payment Food supplier Financial support provided 4019 490 -280 Financial support provided Food supplier -120 Payment 4020 -378 Payment Financial support provided -550 Direct Credit GF donation 20 Payment Rent 860 -500 Payment Office supply store 2425 -75.5 Direct Debit Telecom Ltd 1513686050 -60 Direct Credit GF donation 10 Payment Financial support provided -75 Direct Credit Grant received 1000 Payment Venue hire 1881 -172.5 Food supplier 4025 19/04/21 20/04/21 20/04/21 23/04/21 Payment -305 Direct Credit GF donation 100 Payment Repairs & Maintenance 448 -350 Direct Credit Bequest - James Secretan Food supplier Food supplier 2000 23/04/21 24/04/21 25/04/21 25/04/21 26/04/21 29/04/21 Payment 4028 -259 Payment 4029 -473 Direct Credit GF donation 20 Payment Petrol -43 Payment Petrol -97 Direct Debit Energy and Gas Ltd 2517548234 -62
Transcribed Image Text:Туре Details Particulars Code Reference Amount Date ForeignCurrencyAmount ConversionCharge Food supplier 1/04/21 3/04/21 5/04/21 5/04/21 6/04/21 6/04/21 7/04/21 7/04/21 8/04/21 8/04/21 8/04/21 9/04/21 10/04/21 11/04/21 13/04/21 14/04/21 17/04/21 19/04/21 19/04/21 19/04/21 Payment 4017 -343 Transfer GF fundraising 1800 Direct Credit GF donation 20 Payment Petrol -68 Payment Financial support provided -230 Payment Venue hire 1878 -172.5 Direct Credit GF donation 50 Payment Payment Payment Food supplier Financial support provided 4019 490 -280 Financial support provided Food supplier -120 Payment 4020 -378 Payment Financial support provided -550 Direct Credit GF donation 20 Payment Rent 860 -500 Payment Office supply store 2425 -75.5 Direct Debit Telecom Ltd 1513686050 -60 Direct Credit GF donation 10 Payment Financial support provided -75 Direct Credit Grant received 1000 Payment Venue hire 1881 -172.5 Food supplier 4025 19/04/21 20/04/21 20/04/21 23/04/21 Payment -305 Direct Credit GF donation 100 Payment Repairs & Maintenance 448 -350 Direct Credit Bequest - James Secretan Food supplier Food supplier 2000 23/04/21 24/04/21 25/04/21 25/04/21 26/04/21 29/04/21 Payment 4028 -259 Payment 4029 -473 Direct Credit GF donation 20 Payment Petrol -43 Payment Petrol -97 Direct Debit Energy and Gas Ltd 2517548234 -62
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Bank reconciliation statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS