practice_exam_instructions
pdf
keyboard_arrow_up
School
Sheridan College *
*We aren’t endorsed by this school
Course
10000
Subject
Accounting
Date
Jan 9, 2024
Type
Pages
10
Uploaded by AmbassadorThunderLeopard27
SAGE 50 ACCOUNTING
PRACTICE TEST
This test requires you to process transactions in ALL Ledgers for a company named
WING DINGS
,
who specializes in tattoo design, application, and removal.
READ These Instructions FIRST:
If you do NOT have an active database ready for this exam
, you must first do the following:
•
On your computer:
o
Create a folder in your ASA course folder and call it something memorable, like
PRACTICE.
•
In Slate:
o
Go to the
Content ->
Practice E
xam
and download
the file called
wing_dings_bu
to your PRACTICE file folder.
•
Back to your computer:
o
Start Sage
o
Restore the Wing Dings company from the .CAB file.
o
Hopefully you’re in the habit of going to SETTINGS, then Company Information
and adding YOUR NAME to the company name. (
Keep in mind, if this step has
not been processed, your submission will NOT be graded! Meaning you will get a
grade of zero!)
You should be able to process all requirements within 2 hours.
Watch the TIME! (The half-way point is at the end of page 6.)
Process EACH of the following tasks IN ORDER.
Keep in mind accounting is all about paying attention to details. We’ve hidden some details in
these transactions that, if you miss them, will cost you marks. PAY ATTENTION TO THE
DETAILS!
For your information
1.
Here is the opening trial balance
WING DINGS
Trial Balance
April 1, 2022
Debit
Credit
1080 Bank: CAD Chequing
$25 680
1100 Bank: Credit Card
2 200
1200 Accounts Receivable
2 800
1240 Loans Receivable
150
1280 Sterilized Needles
650
1300 Store Supplies
400
1420 Computers & Video Monitors
6 500
1440 Sterilization Equipment
4 800
1460 Tatoo Equipment
12 000
1480 Store Fixtures & Displays
4 500
1490 Laser Equipment
120 000
1620 Tatoo Designs
10 800
1640 Ink
1 030
2100 Bank Loan
$ 6 000
2150 Credit Card Payable
1 200
2200 Accounts Payable
4 500
2300 Vacation Payable
360
2310 EI Payable
145
2320 CPP Payable
390
2330 Income Tax Payable
625
* 2650 HST Charged on Sales
1 890
* 2670 HST Paid on Purchases
1 620
2850 Mortgage Payable
60 000
3560 Owner, Capital
_______
118 020
$193 130
$193 130
2.
All sales and purchases are subject to HST @ 13% (unless otherwise noted).
3.
Cash/Cheque Sales Transactions default to the ‘Undeposited Cash & Cheques Account’ #1060
4.
Cash/Cheque Purchase Transactions default to the ‘Bank CAD Chequing Account’ #1080
5.
All Credit Card transactions are to be processed to HOPEFULL credit card.
6.
Employee Danny Drawer is entitled to 2% commission on all sales
7.
Partial payments, partial receipts are ineligible for discounts
8.
When creating new customer, supplier and general ledger accounts, use the information provided
in this document, leave all other Sage settings as the default setting.
Transactions for you to complete
1)
Create A Supplier Account.
Supplier: Ink Inspector
Terms: N30
Exp acct: 5250 Licenses
Address: Oakville, ON
Tax Code: HI (HST @ 13%, included)
2)
Create A Customer Account.
Client: Noya Modeling Agency
Terms: 1/15, N30
Rev acct: 4050 Rev from services
Address: Hamilton, ON
Tax Code: H (HST @13%)
Credit Limit: $10,000
Change the Session Date to April 8, 2022
3)
Enter the following transactions into Sage.
Purchase Invoice #GB-806
Dated April 4 from Germ Busters; $3,750, plus HST for new sterilization equipment (add freight charges
of $225 + HST). (
Pay attention to the words! This is not sterilized needles; this is for sterilization
equipment. You need to change the account number.
)
Sales Invoice
Dated April 4 to Noya Modeling Agency $8,000, plus HST for laser treatments to remove tattoos on new
models hired in the agency.
Credit Card Sales Invoice
Dated April 4 to One-Time walk-in clients. Sales Summary: $1,420, plus HST for laser treatments.
Payment Cheque
Dated April 5 to Dye Masters in payment of Invoice #DM-5379 (take the discount available)
Payment Cheques
Dated April 5 to Flesh Decorators in payment of Invoice #FD-364
Cheque Purchase Invoice #LS-35887
Dated April 5 from NEW vendor Law Sum (use Quick Add); $930, including HST for professional legal
services. Terms: Net 10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Credit Card Purchase Invoice #KK-896
Dated April 5 from NEW vendor King Kopy (use Quick Add); $580, plus HST for producing
informational DVDs. Create a NEW Group Account 5225 ‘Promotional Expense’. Terms: N20
Cheque Receipt
Dated April 6 from Murray Misery for remaining payment due (including discount taken) for Invoice
#2435. Record Cheque #44
Memo #1
Dated April 7 Adjust Sales Invoice #2550 to Noya Modeling Agency. They will become a contract client.
Instead of a one-time bill of $8,000, they will now be invoiced $2,000 bi-weekly (plus HST) until the
current treatment plan is completed. Store this sales invoice as a recurring transaction.
Purchase Invoice #FD-495
Dated April 7 from Flesh Decorators to fill purchase order #55 in full (we received everything we
ordered. Add freight charges of $100 + HST.
Memo #2
Dated April 8
A box of surgical gloves/masks and a box of sterilized needles have been contaminated. Write-off $150
worth of Store Supplies & $75 worth of Sterilized Needles to the supplies expense account. (Note, these are
not inventory items. The gloves/masks are from the Store Supplies account and the sterilized needles are
from the Sterilized Needles account.)
Change the Session Date to April 15, 2022
4)
Enter the following transactions into Sage.
Cash Sales Invoice
Dated April 11 from One-Time walk-in clients: (regular pricing + HST)
12 of 101 Ink – Permanent Colour
$120
12 of 102 Ink – Permanent Outline
72
6 of 201 Ink – Temporary Colour
48
6 of 202 Ink – Temporary Outline
42
15 of 301 Designs – Small
375
15 of 501 Tattoo Applications
1,200
Memo #3
Dated April 11; Transfer $2,500 from ‘Bank: Credit Card’ to ‘Bank: CAD Chequing Account’
Payment Cheque
Dated April 12 to Germ Busters; $2,500 in partial payment of Invoice #GB-806
Cheque Receipt
Dated April 12 from Noya Modeling Agency for $2,260 for invoice #2550. Record Cheque #316
(Discount not applicable due to special pricing in contractual arrangement.)
Sales Order
Dated April 13 Convert Sales Quote #32 for Sunshine Weddings to a Sales Order. Adjust the order in
accordance with the following details and offer preferred pricing for each of the items ordered:
20 of 101 Ink – Permanent Colour
$
160
20 of 102 Ink – Permanent Outline
100
20 of 302 Designs – Medium
1,000
20 of 501 Tattoo Applications
1,400
*
Record a $750 deposit made on this order with Cheque #791
Credit Card Payment
Dated April 13 to Hopefull for $900 for purchases made up to the March 31 statement date plus an
additional $55 for annual credit card fees. (Total $955). (Note: This is different than the amount recorded
in Sage as we will only pay the amount listed on the latest statement.) Accept the assigned cheque number
as the source number.
Cash Purchase Invoice #GB-1010
Dated April 14 to Germ Busters; $675, plus HST for a skid of sterilized needles.
Payroll #1
Dated April 15
Pay hourly employee, Amy Artist for 35 hours regular work and 7 hours of overtime from
Apr 1st to
15
th
.
Artist should also be paid for serving 15 clients. Add $100 for an additional loan.
Payroll #2
Dated April 15
Make payroll tax remittance to the Receiver General
for the pay period ending April 1st
Include remittance for Income Tax, EI & CPP. Reference #MarchStats
Deposit Slip #607
Dated April 15; deposit all 3 cheques received since April 1, totaling $5,767.00 and cash consisted of 18
×
$5,
12
×
$10, 14
×
$20, 10
×
$50, 11
×
$100 & $8.41 in coins (cash total of $2,098.41).
Total deposit amount to ‘Bank: CAD Chequing’ account = $7,865.41
Sales Invoice
Dated April 15 Convert Sales Order #32 for Sunshine Weddings to a client invoice for half of the order
(for the bride’s party only. The groom’s party will book later.)
Bank Memo # HB-77225
Dated April 15 from Hijak Bank; NSF Cheque #316 from Noya Modeling Agency. Process the negative
receipt to reverse the original entry.
(Pay attention to the details. The credit should be to the bank
account, not Undeposited Cheques and Cash.)
After the invoice has been re-established, adjust it to bill
an additional $20 for bank service charges (no HST). (Use account 5010 Credit Card and Bank Fees. )
Change the Session Date to April 22, 2022
5)
Enter the following transactions into Sage.
Sales Invoice
Dated April 18 to Noya Modeling Agency for recurring bi-weekly billing.
Credit Card Sales Invoice
Dated April 19 from Silly Willy Costumes for 25 Design Creations @ $250 each + HST (
Pay attention to
the details. This is a credit card transaction. No sales discounts allowed.
)
Purchase Invoice #DM-5821
Dated April 19 from Dye Masters: Add freight charges of $80 + HST
26 of 101 Ink – Permanent Colour
$1,040.00
26 of 102 Ink – Permanent Outline
1,300.00
34 of 201 Ink – Temporary Colour
1,700.00
34 of 202 Ink – Temporary Outline
1,360.00
Cash Receipt
Dated April 20 from Murray Misery; advance deposit of $100 for booking a partial tattoo removal and re-
design. Cheque 157
Credit Card Purchase Invoice #II-6310
Dated April 20 from Ink Inspectors; $720, including HST for renewal of license and site inspection.
Cheque Purchase Invoice #DM-6273
Dated April 20 from Dye Masters for a tattoo gun costing $4,290 (add $60 + HST for freight charges).
Paid with cheque #327.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Cheque Sales Invoice
Dated April 21 from Silly Willy Costumes: Record Cheque #658
40 of 201 Ink – Temporary Colour
$280
40 of 202 Ink – Temporary Outline
200
23 of 302 Designs – Medium
1,380
17 of 303 Designs – Large
1,700
Provide preferred pricing to this client on the ink purchases only.
Memo #4
Dated April 21
Several boxes of inventory were damaged after a truck backed onto a skid in the parking lot.
The following items are not usable and require adjustment (accept the cost price):
20 of 101 Ink - Permanent Colour
15 of 201 Ink - Temporary Colour
Change the Session Date to April 30, 2022
6)
Enter the following transactions into Sage.
Sales Invoice - Credit Note #CN-2553
Dated April 25 to Sunshine Weddings. A tattoo applied on April 15 smudged shortly after application.
Create a negative invoice and give credit for 1 Tattoo Application at the preferred price, plus HST.
Edit out default terms. Create a NEW Group Account 4200 “Sales Returns & Allowances”
Purchase Order
Dated April 26 to Flesh Decorators for 15 Special Order Designs @ $150 each + HST
*
Paid $500 in advance by cheque to secure this customized special order.
Purchase Invoice – Debit Note #DN-5821
Dated April 26 from Dye Masters for a purchase allowance/credit of one 101 Ink - Permanent Colour that was
sent in the wrong shade. Edit out default terms.
Credit Card Receipt
Dated April 27 from Sunshine Weddings for the balance of their account. (Be sure to apply the pre-paid
deposit.)
Bank Debit Memo #HB-96445
Dated April 28 from Hijak Bank:
$700 for mortgage payment, including $90 for interest and $610 for principal.
$500 for bank loan payment, including $110 for interest and $390 for principal.
Total amount withdrawn from the ‘Bank: CAD Chequing ‘account is $1,200
Payroll #3
Dated April 29
Pay hourly employee; Amy Artist for 35 hours regular work from Apr 16th to 29th
Artist should also be paid for serving 12 clients. Recover $125 for previous loans.
Payroll #4
Dated April 29
Pay salaried employee; Danny Drawer his regular salary and $387.34 in commission from Apr 1st to 29th
Memo #5
Dated April 29; Net HST owing to Receiver General from April 1
st
to 22
nd
Use the tax summary report to determine amount owing and process a cheque in the payment journal.
Memo #6
Dated April 29; Record amortization/depreciation in the amount of $675 on capital equipment.
Deposit Slip #608
Dated April 29; deposit all cheque received since April 01, and $100 in cash (5
×
$20)
Back-Up Your Work!
7)
Bank Reconciliation;
Set-up Account #1080 ‘Bank: CAD Chequing’ for reconciliation.
Link the following accounts (create new accounts as necessary)
Income 1: Name = Interest Revenue (Create Account #4250 Interest Revenue)
Expense1 & 2: Name = Bank Charges & NSF (Link Account #5010 Credit Card & Bank Fees)
Adjustment: Name = Bank Reconciliation (Create Account #5025 Bank Rec Errors)
April 1 is the statement start date and April 30 is both the statement end date and the reconciliation date.
NOTE:
There are two prior outstanding transactions that need to be input:
Source
Description
Date
Amount
460
Deposit Slip
Mar 31
Deposit: $2,600
310
Flesh Decorators
Mar 31
Withdrawals: $1,800
Use the following bank statement details to complete the reconciliation;
Date
Description
Withdrawals
Deposits
Balance
31-Mar-22
Opening balance
$ 24,880.00
01-Apr-22
Deposit 460
2,600.00
27,480.00
01-Apr-22
Cheque 300
(1,800.00)
25,680.00
01-Apr-22
Interest on account
15.00
25,695.00
09-Apr-22
Cheque 321
(2,000.00)
23,695.00
10-Apr-22
Cheque 320
(940.50)
22,754.50
11-Apr-22
Transfer - Bank: Credit Card
2,500.00
25,254.50
12-Apr-22
Cheque 322
(930.00)
24,324.50
12-Apr-22
Deposit 607
7,865.41
32,189.91
15-Apr-22
DD Payroll
(863.85)
31,326.06
15-Apr-22
NSF - Noya Modeling
(2,260.00)
29,066.06
15-Apr-22
NSF - Service Fee
(20.00)
29,046.06
18-Apr-22
Cheque 323
(2,500.00)
26,546.06
18-Apr-22
Cheque 325
(755.12)
25,790.94
20-Apr-22
Cheque 326
(1,160.00)
24,630.94
21-Apr-22
Cheque 324
(955.00)
23,675.94
27-Apr-22
Cheque 327
(4,669.72)
19,006.22
28-Apr-22
ETF Loans #HB-96445
(1,200.00)
17,806.22
29-Apr-22
Cheque 328
(500.00)
17,306.22
29-Apr-22
DD Payroll
(471.79)
16,834.43
29-Apr-22
DD Payroll
(1,758.23)
15,076.20
29-Apr-22
Service Fee
(45.00)
15,031.20
29-Apr-22
Ending balance
15,031.20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
10) Export the following reports to Excel and check the solutions for accuracy:
PAY ATTENTION TO THE DATES FOR THESE REPORTS. SAGE DOES NOT START OFF
THEIR REPORTS WITH THESE DATES. WE’RE TRYING TO SEE IF YOU’RE PAYING
ATTENTION. UPLOAD REPORTS WITH THE WRONG DATES AND YOU GET ZERO!!!
•
Trial Balance at April 30, 2022
•
ALL General Ledger Accounts from April 1 to April 30, 2022
o
including corrections (miss this and you lose marks)
•
ALL Journal Entries from April 1 to April 30, 2022
o
including corrections (miss this and you lose marks)
•
Balance Sheet at April 30, 2022
•
Income Statement from April 1 to April 30, 2022
•
Supplier Aged Detail at April 30, 2022
•
Customer Aged Detail at April 30, 2022
•
Bank Reconciliation Summary at April 30, 2022
Back-Up Your Work!
Related Documents
Related Questions
Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".
arrow_forward
Accounting Excel Practice Problem - I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formula figured out.
arrow_forward
A software package where an entry for a purchase on account updates both the general ledger and the vendors ledger is an example of:
Question 45 options:
an accounting database program
an integrated accounting software package such as Sage 50 or QuickBooks
a one-step accounting package
an excel add-on program.
arrow_forward
Industry Tools Research
Your manager has asked you to recommend an industry tool for purchase. Select one of the following tools to research: ACL, IDEA, Microsoft Visio, Oversight, Power BI, Alteryx, and Tableau.
Identify key features of each tool.
Discuss how auditors can incorporate the tool into their audits.
Additional learning opportunities: If you are interested in learning more about data analytics and emerging technologies in accounting, join the Institute of Management Accountants (IMA) for only $25 per year: Students | IMA - The association of accountants and financial professionals working in business.Links to an external site. (Use code Student22). Gain access to Free courses, training, and webinars.
arrow_forward
Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).
arrow_forward
Question 9
Denise would like for all of her leads to save their notes in the Client
details screen.
Who would have access to these notes?
Team members assigned to the client
O All team members
Full access team members
O Custom access team members
arrow_forward
Question 11
What are the 3 types of user permissions you can choose from in
QuickBooks Online Accountant when adding new team members to
your firm?
View-only access
Basic access
Custom access
Full access
Edit access
Lead access
arrow_forward
What are 2 tools you can use to identify possible issues in a QuickBooks Online company?
Transaction Journal
Import Data
Account and Settings
Audit Log
Journal Entry
arrow_forward
Microsoft or Tableau
Using the skills you have gained throughout this text, use Microsoft Power BI or Tableau Desktop to complete the generic tasks presented below:
Build a new dashboard (Tableau) or page (Power BI) called Financial that includes the following:
Create a new workbook, connect to 10-1 O2C Data.xlsx, and import all seven tables. Double-check the data model to ensure relationships are correctly defined as shown in Exhibit 10-1.
Add a table to your worksheet or page called Sales and Receivables that shows the invoice month in each row and the invoice amount, receipt amount, adjustment amount, AR balance, and write-off percentage in the columns. Tableau Hint: Use Measure Names in the columns and Measure Values in the marks to create your table. Then once your table is complete, use Analytics > Summarize > Totals to calculate column totals.
You will need to create a new measure or calculated field showing the account AR Balance, or the total invoice amount minus…
arrow_forward
Please see attached image for instructions. Thank you for your help!
arrow_forward
X
Topic: Discussion - What is the rol X +
rses/1545/discussion_topics/15677?module_item_id=111468
Q Search entries or author...
All
>
↓ Sort
View Split Screen
Expand Threads
You must post before seeing replies. Edit history will be available to instructors.
Due Jan 4, 2025 11:59pm
时☆
10 points possib
Discussion - What is the role of ethics in accounting?
Requirement:
Include Introduction, Body, and Conclusion.
Your initial Discussion posting should be at least 150 words in length.
9 Replies, 9 Unread
Be sure to include a related Title, at least two different citations and references to support your statement
Read and post brief responses to at least two of your classmates' postings (minimum 75 words).
arrow_forward
Examity Dashboard (click this
Question 2 - Chapter 12 Home x
O ezto.mheducation.com/ext/map/index.html?.con=con&external browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%25
Chapter 12 Homework a
Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate comp
Zachary Services Company has 61 employees, 36 of whom are assigned to Division A and 25 to Division B. Zachary incurred $364,170
of fringe benefits cost during year 2.
20
points
Required
Determine the amount of the fringe benefits cost to be allocated to Division A and to Division B.
O Answer is complete but not entirely correct.
Allocated
Cost
Division
A
s 160,420 O
B
$ 172,760
MacBook Air
arrow_forward
Question 9
When logged into QuickBooks Online Accountant, where can you
view apps that are connected to a client's QuickBooks Online?
Apps > Firm apps
O Apps > QuickBooks apps
Apps > Client apps
Apps > Find apps
arrow_forward
How can you display or print a batch or group of reports quickly?
A. Create a memorized group of reports.
B. Click Batch Reports from the Home Page
C. Click Reports > Process multiple reports
D. You cannot do this in Quickbooks
arrow_forward
Need your help please
arrow_forward
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
- Chapter 6 Exercise X
Study the Accounting Methods
XGA company that usually sells sate x
New tab
+| x
pter 6 Exercises (Static) -
education.com/ext/map/index.html?_con%3Dcon&external_browser%3D0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.
ation.com
duct Release
ADP
SCM
Request
Service
In-Process Inspection A-Trax Dashboard..
ATRONA PORTAL
6 Exercises (Static)
Check my work mode : This shows what is correct or incorrect for the work you have complete
A company that usually sells satellite TV equipment for $50 and two years of satellite TV service for $450 has a special, time-limited
offer in which it sells the equipment for $300 and gives the two years of satellite service for "free."
If the company sells one of these packages on July 1, how much revenue should the company recognize on July 1 when it delivers the
equipment and receives the full price in cash? (Do not round intermediate calculations.)
XAnswer is complete but not entirely correct.
Sales revenue
arrow_forward
Assignment Content
APPLICATION 5 - Internal Controls for Fraud Prevention (Webinar)
1. Watch the video below (approx. ~1hr) then answer the questions below
arrow_forward
11
Question 8 of 100
learning Mu Crowd Wisdo X M Accounting Exam Details - Star x
n/diweb/?wicket:interface=:32::::
Depending on the specific needs of a business, a separate special journal is
designed for each:
O
OA. type of transaction the business normally undertakes.
O
B. major repetitive activity or event.
C. product or service marketed.
O D. account classification.
← Prev Question
Himalaya Assessment Engine
acer
CHAA FURT PH
Next Question →
arrow_forward
I need typing clear urjent no chatgpt used i will give 5 upvotes pls full explain
arrow_forward
Which 2 statements about creating a client request in QuickBooks
Online Accountant are true?
A document request notification can be sent via email by selecting Notify
client
A document request can be sent to a non-QuickBooks Online client
A document request appears in the client's QuickBooks Online company in
the Accounting menu
The status of a document request cannot be updated
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
ngageNOWv2 | Online teachin x
Chapter 4 Corporate Financial Ac x +
/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false
☆
E
1 Welcome - Login.gov
Sign in to your acco...
Control Center
Part 9:
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the
concepts.
Note: You must complete parts 1, 2, 3, 4, 6, 7 and 8 before completing part 9. Part 5 is optional.
Part 9: Prepare the closing entries below. Then, using the attached spreadsheet from part 2, post the entries to your general ledger. If an amount box does not require an entry, leave it blank.
Date
Account Name
Post. Ref.
Debit
Credit
20Y8 Closing Entries
May 31 Fees Earned
40,000 ✓
0
✓
1,705 ✓
0✔
0✓
1,600 ✔
0 ✓
1,370 ✔
0✓
330
0✔
275
✓
1,295 ✔
33,425 ✔
0
10,500
<
Previous
Next
Email Instructor Save and Exit Submit Assignment for Gradin
10:53 PE
--
6/13/202
WIS
V…
arrow_forward
Think about the last time that you purchased something over the internet. What did the checkout page look like? What categories of operational decisions do you think were made by the website operator? What business rules applied?
Provide a real world example of using the following databases in the workplace:
Microsoft Access
Structured Query Language (SQL)
arrow_forward
All qesions answer please ?
50 minets
arrow_forward
Export PDF as long image without watermark
Export
FUNDAMENTALS OF ACCOUNTANCY BUSINESS AND MANAGEMENT 2
Self-Learning Activity 9
Name
Year/Block:
Date
Direction: Write your answers on the space provided at the back of this Self Learning Activity.
Learning Objective:
After reading the module, the learners shall be able to:
4. Describe the nature of a bank reconciliation statement.
5. Identify common reconciling items and describe each of them.
6. Analyze the effects of the identified reconciling items.
Reference: Quarter 1 Module 9 – Fundamentals of Accountancy, Business and Management 2
LEARNING ACTIVITY 9:1
Presented hereunder are the details of your Cash Receipts Journal, Cash Disbursements Journal and the Bank
Statement of Banco de Oro.
Cash Receipts Journal
O.R. Number
Amount
Payor
Odessa Alera
Date
0001
P 30,000
June 3
0002
0003
20,000
5,000
20
Arnold Navales
29
Juanita Nambatac
0004
10,000
30
Kyle Jamora
Cash Disbursements Journal
Check Number
Amount
Payee
Star 5 Grocery
DX…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Related Questions
- Accounting excel practice problem - I already solved the first few sub parts to this question - I just need the last sub part answered. I attached a picture of the instructions and a picture of the excel spreadsheet to answer the remaining "formulas".arrow_forwardAccounting Excel Practice Problem - I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formula figured out.arrow_forwardA software package where an entry for a purchase on account updates both the general ledger and the vendors ledger is an example of: Question 45 options: an accounting database program an integrated accounting software package such as Sage 50 or QuickBooks a one-step accounting package an excel add-on program.arrow_forward
- Industry Tools Research Your manager has asked you to recommend an industry tool for purchase. Select one of the following tools to research: ACL, IDEA, Microsoft Visio, Oversight, Power BI, Alteryx, and Tableau. Identify key features of each tool. Discuss how auditors can incorporate the tool into their audits. Additional learning opportunities: If you are interested in learning more about data analytics and emerging technologies in accounting, join the Institute of Management Accountants (IMA) for only $25 per year: Students | IMA - The association of accountants and financial professionals working in business.Links to an external site. (Use code Student22). Gain access to Free courses, training, and webinars.arrow_forwardAccounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).arrow_forwardQuestion 9 Denise would like for all of her leads to save their notes in the Client details screen. Who would have access to these notes? Team members assigned to the client O All team members Full access team members O Custom access team membersarrow_forward
- Question 11 What are the 3 types of user permissions you can choose from in QuickBooks Online Accountant when adding new team members to your firm? View-only access Basic access Custom access Full access Edit access Lead accessarrow_forwardWhat are 2 tools you can use to identify possible issues in a QuickBooks Online company? Transaction Journal Import Data Account and Settings Audit Log Journal Entryarrow_forwardMicrosoft or Tableau Using the skills you have gained throughout this text, use Microsoft Power BI or Tableau Desktop to complete the generic tasks presented below: Build a new dashboard (Tableau) or page (Power BI) called Financial that includes the following: Create a new workbook, connect to 10-1 O2C Data.xlsx, and import all seven tables. Double-check the data model to ensure relationships are correctly defined as shown in Exhibit 10-1. Add a table to your worksheet or page called Sales and Receivables that shows the invoice month in each row and the invoice amount, receipt amount, adjustment amount, AR balance, and write-off percentage in the columns. Tableau Hint: Use Measure Names in the columns and Measure Values in the marks to create your table. Then once your table is complete, use Analytics > Summarize > Totals to calculate column totals. You will need to create a new measure or calculated field showing the account AR Balance, or the total invoice amount minus…arrow_forward
- Please see attached image for instructions. Thank you for your help!arrow_forwardX Topic: Discussion - What is the rol X + rses/1545/discussion_topics/15677?module_item_id=111468 Q Search entries or author... All > ↓ Sort View Split Screen Expand Threads You must post before seeing replies. Edit history will be available to instructors. Due Jan 4, 2025 11:59pm 时☆ 10 points possib Discussion - What is the role of ethics in accounting? Requirement: Include Introduction, Body, and Conclusion. Your initial Discussion posting should be at least 150 words in length. 9 Replies, 9 Unread Be sure to include a related Title, at least two different citations and references to support your statement Read and post brief responses to at least two of your classmates' postings (minimum 75 words).arrow_forwardExamity Dashboard (click this Question 2 - Chapter 12 Home x O ezto.mheducation.com/ext/map/index.html?.con=con&external browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%25 Chapter 12 Homework a Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate comp Zachary Services Company has 61 employees, 36 of whom are assigned to Division A and 25 to Division B. Zachary incurred $364,170 of fringe benefits cost during year 2. 20 points Required Determine the amount of the fringe benefits cost to be allocated to Division A and to Division B. O Answer is complete but not entirely correct. Allocated Cost Division A s 160,420 O B $ 172,760 MacBook Airarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L

Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L