accounting experts only

profileashley016
20161029215150102916.xlsx
Home>Business & Finance homework help>Accounting homework help>accounting experts only

Sheet1

Kristin Raina Interior Designs Journal (April 1)
Trans # Type Date Num Name Memo Account Debit Credit
1 Inventory Adjust 04/01/2017 Carpets Opening balance 3010 · Kristin Raina Capital 800.00
Carpets Opening balance 1260 · Inventory of Carpets 800.00
800.00 800.00
2 Inventory Adjust 04/01/2017 Draperies Opening balance 3010 · Kristin Raina Capital 1,000.00
Draperies Opening balance 1265 · Inventory of Draperies 1,000.00
1,000.00 1,000.00
3 Inventory Adjust 04/01/2017 Lamps Opening balance 3010 · Kristin Raina Capital 1,000.00
Lamps Opening balance 1270 · Inventory of Lamps 1,000.00
1,000.00 1,000.00
4 Inventory Adjust 04/01/2017 Mirrors Opening balance 3010 · Kristin Raina Capital 900.00
Mirrors Opening balance 1275 · Inventory of Mirrors 900.00
900.00 900.00
5 Invoice 04/01/2017 Berger Bakery Company Opening balance 1200 · Accounts Recievable 600.00
Berger Bakery Company Opening balance 49900 · Uncategorized Income 600.00
600.00 600.00
6 Invoice 04/01/2017 Franco Films Co. Opening balance 1200 · Accounts Recievable 940.00
Franco Films Co. Opening balance 49900 · Uncategorized Income 940.00
940.00 940.00
7 Bill 04/01/2017 Ace Glass Works Opening balance 2010 · Accounts Payable 1,500.00
Ace Glass Works Opening balance 69800 · Uncategorized Expenses 1,500.00
1,500.00 1,500.00
8 Bill 04/01/2017 Bell Carpet Design Opening balance 2010 · Accounts Payable 2,000.00
Bell Carpet Design Opening balance 69800 · Uncategorized Expenses 2,000.00
2,000.00 2,000.00
9 Bill 04/01/2017 Cuza and Carl Associates Opening balance 2010 · Accounts Payable 400.00
Cuza and Carl Associates Opening balance 69800 · Uncategorized Expenses 400.00
400.00 400.00
10 Bill 04/01/2017 Galeway Computers Opening balance 2010 · Accounts Payable 2,600.00
Galeway Computers Opening balance 69800 · Uncategorized Expenses 2,600.00
2,600.00 2,600.00
11 Bill 04/01/2017 Midwest Mutual Insurance Co. Opening balance 2010 · Accounts Payable 2,400.00
Midwest Mutual Insurance Co. Opening balance 69800 · Uncategorized Expenses 2,400.00
2,400.00 2,400.00
12 Bill 04/01/2017 Minneapolis Electric & Gas Co. Opening balance 2010 · Accounts Payable 450.00
Minneapolis Electric & Gas Co. Opening balance 69800 · Uncategorized Expenses 450.00
450.00 450.00
13 Bill 04/01/2017 Williams Office Supply Company Opening balance 2010 · Accounts Payable 400.00
Williams Office Supply Company Opening balance 69800 · Uncategorized Expenses 400.00
400.00 400.00
TOTAL 14,990.00 14,990.00

&"Arial,Bold"&8 1:45 PM &"Arial,Bold"&8 10/29/16 &"Arial,Bold"&8 &"Arial,Bold"&12 CH7 [Your Name] Kristin Raina Interior Designs &"Arial,Bold"&14 Journal &"Arial,Bold"&10 April 1, 2017

&"Arial,Bold"&8 Page &P of &N

Sheet2

Kristin Raina Interior Designs Trial Balance (April 1)
Apr 1, 17
Debit Credit
1200 · Accounts Recievable 1,540.00
1260 · Inventory of Carpets 800.00
1265 · Inventory of Draperies 1,000.00
1270 · Inventory of Lamps 1,000.00
1275 · Inventory of Mirrors 900.00
2010 · Accounts Payable 9,750.00
3010 · Kristin Raina Capital 3,700.00
49900 · Uncategorized Income 1,540.00
69800 · Uncategorized Expenses 9,750.00
TOTAL 14,990.00 14,990.00

&"Arial,Bold"&8 2:26 PM &"Arial,Bold"&8 10/29/16 &"Arial,Bold"&8 Accrual Basis &"Arial,Bold"&12 CH7 [Your Name] Kristin Raina Interior Designs &"Arial,Bold"&14 Trial Balance &"Arial,Bold"&10 As of April 1, 2017

&"Arial,Bold"&8 Page &P of &N

Sheet1 (3)

Kristin Raina Interior Designs Profit & Loss Standard Report (Jan 1 - April 1)
Jan 1 - Apr 1, 17
Ordinary Income/Expense
Income
49900 · Uncategorized Income 1,540.00
Total Income 1,540.00
Gross Profit 1,540.00
Expense
69800 · Uncategorized Expenses 9,750.00
Total Expense 9,750.00
Net Ordinary Income -8,210.00
Net Income -8,210.00

&"Arial,Bold"&8 2:24 PM &"Arial,Bold"&8 10/29/16 &"Arial,Bold"&8 Accrual Basis &"Arial,Bold"&12 CH7 [Your Name] Kristin Raina Interior Designs &"Arial,Bold"&14 Profit && Loss &"Arial,Bold"&10 January 1 through April 1, 2017

&"Arial,Bold"&8 Page &P of &N

Sheet1 (4)

Kristin Raina Interior Designs Balance Sheet (April 1)
Apr 1, 17
ASSETS
Current Assets
Accounts Receivable
1200 · Accounts Recievable 1,540.00
Total Accounts Receivable 1,540.00
Other Current Assets
1260 · Inventory of Carpets 800.00
1265 · Inventory of Draperies 1,000.00
1270 · Inventory of Lamps 1,000.00
1275 · Inventory of Mirrors 900.00
Total Other Current Assets 3,700.00
Total Current Assets 5,240.00
TOTAL ASSETS 5,240.00
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable
2010 · Accounts Payable 9,750.00
Total Accounts Payable 9,750.00
Total Current Liabilities 9,750.00
Total Liabilities 9,750.00
Equity
3010 · Kristin Raina Capital 3,700.00
Net Income -8,210.00
Total Equity -4,510.00
TOTAL LIABILITIES & EQUITY 5,240.00

&"Arial,Bold"&8 2:17 PM &"Arial,Bold"&8 10/29/16 &"Arial,Bold"&8 Accrual Basis &"Arial,Bold"&12 CH7 [Your Name] Kristin Raina Interior Designs &"Arial,Bold"&14 Balance Sheet &"Arial,Bold"&10 As of April 1, 2017

&"Arial,Bold"&8 Page &P of &N

AQAEF1RyaW

FsIEJhbGFuY2

AQAEF1RyaW

FsIEJhbGFuY2

AQAAAAkFAS

AAAAAAAAA

AQAAAAkFAS

AAAAAAAAA

AQAEF1Byb2

ZpdCAmIExvc

AQAEF1Byb2

ZpdCAmIExvc

AQAAAAkFAS

AAAAAAAAA

AQAAAAkFAS

AAAAAAAAA

AQAEF0JhbG

FuY2UgU2hlZ

AQAEF0JhbG

FuY2UgU2hlZ

AQAAAAkFAS

AAAAAAAAA

AQAAAAkFAS

AAAAAAAAA

1

2

3

4

5

6

7

8

9

A

B

C

D

E

F

Trans #

Type

Date

1

Inventory Adjust

04/01/2017