How to keep accounts with excel and how to do accounts with excel?

If you have a foundation in accounting, you can play freely.

Here's how I did it: Table 1 Accounts: Ledger Accounts, Detail Accounts, Shortcodes, Beginning Balances, Current Debits, Current Credits Cumulative Debits, Cumulative Credits, Closing Balances, Total Opening, Total Current Debits, Total Current Credits, Cumulative Total Debits, Total Credits, Total Balances:

The manual part is: Beginning of the year balance, new active account.

Table 2: Month, Voucher Number, Summary, Account Code, General Ledger**, G/L Account, Active Account, Debit Amount Credit Amount Manually entered is, month, voucher number, summary, account code, debit amount, credit amount.

The manual operation is the above two tables, and the following others are automatically generated.

Table 3: Account Summary Table, Equivalent to General Ledger.

Table 4-Table 13, Statement of Assets, Income Statement, Cash Flow Statement (not compiled), Statement of Owners' Equity, Expense Statement, Detailed Account (not I want, the company that buys this table is required, and the input section code is automatically generated), Voucher Inquiry Form (generate another voucher printing format, divided into two types), Provincial Report (directly generate the express report reported to the Provincial Department of Finance on the Internet).

VBA programming, and later learned that many functions can be handled with formula functions.

Many years ago, when I first started my business, the company kept a running account. The main reason is that the company is too small and there are not many personnel, plus it is its own company anyway, and the meat is rotten in the pot, so I don't think there is any need to spend too much energy on bookkeeping. Later, I met a group of students from Sun Yat-sen University who studied finance and accounting, and they suggested that I develop a financial accounting software for the company.

1. First of all, display the desktop right mouse button on the computer, create a new excel shortcut, and double-click to open it.

4. Define the name for the account**: switch to the worksheet that made the account before, and click [Custom Name] in the [Formula] shortcut menu.

5. In the pop-up dialog box, enter the first letter of each word "kmdm" in the name column, and enter "= accounting account" in the reference position! $b$2:$b$26", the purpose of which is to set the data validity.

6. Go back to the accounting voucher worksheet, select "C5:C21" (that is, the account ** column), click [Data Validity] under [Data], select the [Settings] page in the pop-up dialog box, select [Series] in the allow drop-down list, and enter "kmdm" in the [**] text box.

7. Click OK to return to the worksheet, select any cell in the Subjects area, there is a down arrow button on the right side of it, and these subjects are all in it.

1.Take a simple accounting of income and expenditure** as an example. Let's start by opening an Excel blank file. Use this card to record factors such as time, income, expenses, and balances.

2.Click on the A1 blank box with the mouse, and then a blank "value" will appear behind the toolbar A1, and the input here will appear in the A1 box, which is called the key value of A1. Here we define a1 as a time column.

3.Then define B1 as "income", C1 as "expenditure", D1 as "balance", and then you can define the function, which is interesting and important. Click on the d2 box, and then fill in "=b2-c2" in the d2 key value.

4.According to the actual situation, we know that the balance should be equal to the difference between income and expenditure of the day plus the previous balance, so we define the key value of d3 "=b3-c3+d2", and then click on the d3 grid with the mouse, and pull down the mouse, so that all the blank cells in the d column will follow the function of d3 and calculate. This is shown in the figure below.

5.When applying this table, you only need to fill in the entry time, enter the income and expenses at the time, and then ** will automatically generate additional data. The diagram below is a more complete example.

Make a flow statement directly, and then generate a statement of each customer and a sales analysis table (that is, the total sales table of each product) according to this schedule

When making this flow table, it is best to make a list of your products, so that when you enter the product name (or **), you can directly reference the items in the list and fill in some fixed items, so as to reduce the entry work.

For example, the following items are set in the list.

Product**, product name, specification, unit, unit price, etc.

When you enter ** in the schedule, the sales date, name, specification, unit, unit price, etc. are automatically filled in, you only fill in the quantity and customer name, and then the ** is automatically calculated.

It is also possible for each customer to directly establish an independent table, record the details, make a summary table, and count the sales of each customer.

A better approach is to set up an invoice (printable directly) and submit the data to the schedule after filling out the invoice.

According to the name of the generating business company for filtering, the transaction design calculation formula, the total total of revenue, the total total of issued total, and the total balance.

Point filter to settle the balance of a single room (automatically settled due to the design calculation formula), and the filter summary is all sales.

You send me an email to enter the things you need to make into excel2003, email address, I will help you make some buttons to help you make a frame, o( o haha, it's very easy!

The method and detailed operation steps are as follows:

1. The first step, open Excel2010, design the style of the purchase form, see the figure below, go to the steps below.

2. In the second step, after performing the above operations, click the cell to calculate the result, and then click the "Insert Function" button, see the image below, go to the steps below.

3. In the third step, after performing the above operations, select the "if" function, and then click the "OK" button, see the figure below, and go to the steps below.

4. In the fourth step, after performing the above operations, set the calculation formula in the first parameter, such as multiplying the unit price by the quantity, and then determine whether it is equal to 0. Enter a pair of double quotation marks in the second parameter, i.e. 0 is not displayed. The third parameter is to enter the unit price multiplied by the quantity, that is, if it is not 0, the calculation result is displayed, see the image below, go to the steps below.

5. In the fifth step, after performing the above operations, fill in the formula and set the cells, click the cells after "lowercase" to insert the function, see the figure below, go to the steps below.

6. In the sixth step, after performing the above operations, select the if function, the above method determines whether the sum is 0, if it is 0, it is not displayed, if it is not 0, the calculation result is displayed, see the figure below, go to the steps below.

7. In the seventh step, after performing the above operations, click the cell behind "uppercase", and then enter the result equal to lowercase, set the cell format to special, and use Chinese uppercase numbers, when entering data, the rest are automatically calculated results, see the figure below. In this way, the problem is solved.

Hope to be adopted by you.

1.First of all, open the sample table of a working branch as an example.

2.Click the File tab in the toolbar.

3.Click the New option.

Some business partners will do accounts on the **, excel is our commonly used ** tool, so how to do it on excel? The following is the method of excel bookkeeping that I have compiled for your reference.

Take a simple accounting of income and expenditure** as an example. Let's start by opening an Excel blank file. Use this card to record factors such as time, income, expenses, and balances.

We use the mouse to click on the A1 blank box, and then a blank "value" appears behind the toolbar A1, and the input here will appear in the A1 box, which we call the key value of A1. Here I define a1 as a time column.

Then we define B1 as "income", C1 as "expenditure", D1 as "balance", and then we can define the function, which is more meaningful and important. Let's click on the d2 box and fill in the d2 key content with "=b2-c2".

We know according to the actual situation that our balance should be equal to the difference between income and expenditure of the day plus the previous balance, so we define the key value of d3 "=b3-c3+d2", and then click on the d3 grid with the mouse, pull down the mouse and scatter, and then let all the blank cells in the d column follow the function of d3 and calculate. This is shown in the figure below.

The question is too general. To the professional ** can find ready-made templates.