Posts Tagged ‘ledger’

PostHeaderIcon Excel 2008 Ledger Sheets


Manage your finances with preformatted Ledger Sheets built-in to Excel 2008 for Mac.

PostHeaderIcon OnCare Office – Adding One Time Transactions to the Ledger


Adding One Time Transactions to Gen Ledger of OnCare Office

PostHeaderIcon How the controling account in the genral ledger relates to the vendor account?

The question is “Explain how the controlling account in the general ledger relates to the vendor accounts in the subsidiary ledger?”

I am so confused about this question. From my understanding, each company will have their own vendor accounts.For example, a company has 5 vendors. When it wants to check how much it owes from 5 vendors, it will check its account payable in general ledger. And if it wants to check how much it owe from a specific vendor, it will check a specific account payable of the vendor.

Is it rite? I am not sure I understand the question?

PostHeaderIcon TopCAATs – Ledger split


Split ledgers using TopCAATs – www.topcaats.comTopCAATs is a collection of tools designed to make the lives of auditors, accountants and other finance professionals easier. TopCAATs is an add-in for Microsoft Excel that adds over 100 functions and features all focused towards accounting auditing. For more information and to download a free 30-day trial visit www.topcaats.com TopCAATs includes all the tools that you would expect from a high end generalised audit software, such as Benfords testing, Gap detection and Monetary Unit Sampling. Every day, TopCAATs is used by hundreds of finance professionals in over 60 countries – helping them to detect errors, detect fraud, save time and improve profitability.

PostHeaderIcon How to put these in a Gerenal Ledger and Trail Balance?

Need some help?
On February 9th you assumed the job of bookkeeper for Jones Law Company. The previous booker quit with notice on January 3st and burned the account records on his way out. Fortunately, Jones, the owner kept a copy of the chats of accounts. Post-closing trail balance, and schedules of A/R and A/p
The owner wrote memos for all transactions that occurred between 1/31/0x and your arrival on 2/2/0x. Starting on the 9th, he put all the invoice in you box, as well as copies of the any checks he writes and memes of instruction. For February, records the transaction in the general journal and post to the general ledger accounts.
Post-closing trail balance -1/31/00
Account Name DR CR
Cash 10,000
A/R 15,650
Office Supplies 400.00
Office Equipment 7,000
Accumulated dep-office equip 2,450
Office Furniture 12,500
Accumulated – office Furn 4,500
A/P 5,600
Capital 33,050
Total 45,550 45,550

A/P Balance 1/31/0x Consist of:
Motorola 435.00
Smith Company 815.00
Doug’s Printing Shop 2,300
Amway Corp. 50.00
Christensen 2,000
Total 5,600

A/R Balance 1/31/0x consist of:
Laooca Motors 5,500
Microsoft 2,200
Sega 1,500
Stendhal Inc. 3,650
Questionable Enterprises 2,800
Total 15,650
Check Figures
February Net income 17,411.00
February 28th cash balance 3,430.00

Memo
2/1/x0 Issued Check # 5347 to Dell Computer in the amount of 3,300 to Purchase a new computer and Printer.
2/2/0x Issued Check # 5348 in the amount of 2,400 to Trust co Insurance Agency for the next 12 months’ Liability insurance 2/1/0x-1/31/0y
2/3/0x Received payment of 5,550 on account from Iacocca Motors for work performed in January. ** Don’t worry about post in individual customer’s or vender’s accounts (subsidiary Ledgers.) I do that

2/4/xx Purchases 1,500 of Office supplies on account from office Max

2/6/0x Issued Check #5349 in the amount 1,200 to Rodriguez Property Management for February’s rent.

2/6/0x Received and deposited 1,500 payments from Sega and 2,200 payments from Microsoft on account (for work performed in January)

2/9/0x Legal services was provide for the following client’s: Withier 3,400 s&S produce 2,200; College 4,600; Wu consulting 3,800; Mooney farm 2,100. None of the clients has paid yet.
2/12/0x Printer repair service total due 248.00 due date 3/8/20xx
2/15/xx Received checks from Withier 3,400 and Wu 3,800 on account for work performed the first week of February
2/18/0x Please Issue check #5350 to pay smith Co. (Invoice # 234 or 815) and Check # 5351 to pay Doug’s printing shop (invoice #323499 for 2,300.) Both invoices were already entered as accounts payable in January
2/20/0x During the second and Third week of February Legal services were proved for Withier 3,100; lee Labs 845; Ortega foods 4,500 and spears Boutique 3,700; payments has not yet been received from these clients.
2/24/0x Please issue check # 5352 to office Max for 1,500 (Inv # 22535) on account
2/24/0x Received checks form Ortega 4,500 and Lee Labs 845 on account
2/25/0x Please note I wrote a personal Check for 10,000
2/27/0x Please issue Check #5354 to yourself for 3,200 and check # 5355 to Mark Smith the Legal Secretary for 3,600 ** For simplicity, debit wage & salary expense 6,800 and Credit cash 6,800
2/1-28/0x Telephone Services-current Period 150.00 Due Date; 3/8/0x
2/1-28/0x Postage Meter & postage 352.00 Due date 3/20/0x
2/1-28/0x Utilities Expense 134.00 due date 3/8/0x
This is what I need help on!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!…
2/28/0x Please Prepare a General Ledger Trail Balance. Worksheet and Financial Statement as of 2/28/0x
Please if anyone can help me that would be great I’ve been stressing on this for the last week and I can’t figure out what I’m doing wrong.

PostHeaderIcon The purpose of a governmental entity’s general funds’s Fund Bal. Reserved 4 Inv. of Supplies ledger account is

A. Earmark resources for replacement of supplies
B. Provide for outstanding purchase orders for supplies
C. Prevent improper appropriation of the fund balance to finance a deficit budget
D. Accomplish none of the above

PostHeaderIcon how does a cpa or bookkeeper get the transactions from clients to enter into ledger?

Do they pick it up daily, every other day. Or how does that general process work?

PostHeaderIcon How would you write this on a ledger sheet?

Samantha incorporated MAB, Inc. on February 20, 2009, receiving 10,,000 shares of $1 par value common stock in exchange for $300,000, and becoming the president and secretary/treasurer of the company, respectively. She then deposited the $300,000 into the MAB general checking account with the Sun Trust Bank.

I understand that Sam gains stock and looses cash, but how would this be written on a ledger? Thanks!

PostHeaderIcon how do you debit bank when ledger posting?

to all accounting heroes
please answer my question its kinds urgent for work,
how would you debit bank in general ledgers. i know you have to debit bank and credit everything else, so im just so confused about the numbers in the memos
thanks

PostHeaderIcon A ledger that list all accounts needed to prepare financial statement is called a(n)..?

A. balance sheet
B. general ledger
C. income summary
D. special amount column ledger

?>