AB
1
Gusto is a people platform made for businesses who want to take care of their people. Gusto’s products and services can help small businesses onboard, pay, insure, and engage their teams, in a single integrated, easy-to-use platform that’s loved by over 100,000 modern employers. Not a Gusto customer? Get three months free when you sign up here.
2
Get 3 months free.
3
IMPORTANT READ FIRST:
This spreadsheet is view only. To edit the spreadsheet go to File-> Make a Copy. This will add an editable copy to your own Google Drive.

INSTRUCTIONS:
For your assets and liabilities, choose the type from the dropdown menu and then enter a description for each account. The information you enter will auto-populate in the Balance Sheet template in the following tab. When creating your Balance Sheet you'll just enter the balance of each account.

Light grey cells: You fill in the information

White cells: These cells have formulas that will auto-calculate for you. Do not type into these cells or you will lose the formulas.
4
ASSETS
5
CURRENT ASSETS
6
TYPEDESCRIPTION
7
Bank accountBusiness checking account
8
Bank accountBusiness savings account
9
CashCash on hand
10
Accounts receivableAccounts receivable
11
InventoryMerchandise
12
13
14
15
16
17
18
19
FIXED ASSETS
20
TYPEDESCRIPTION
21
Fixed assetEquipment
22
Intangible assetTrademark
23
24
25
26
27
28
29
30
31
32
33
LIABILITIES
34
CURRENT LIABILITIES
35
TYPEDESCRIPTION
36
Credit cardBusiness credit card
37
Accounts payablesVendors payable
38
Sales tax payableCalifornia sales tax
39
40
41
42
43
44
45
46
47
48
LONG-TERM LIABILITIES
49
TYPEDESCRIPTION
50
Long-term loanBusiness loan
51
Tax liability2017 taxes owed
52
53
54
55
56
57
58
59
60
61