Question 1: How to make a company statement. First, go to the bank to get the statement and then check whether the balances are consistent. Generally, if they are consistent, it means there is no outstanding account.

If they are inconsistent, it needs to be itemized. To check, you can mainly check whether the fund changes in the last few days on the bank statement are consistent with the items in the last few days in your bank journal. You need to list 4 types of unsettled accounts that you should know when doing finance. I won’t write them down< /p>

Question 2: How to make a statement. Statements include statements between the unit and the bank, statements between the unit and related units, statements between the unit and individuals, etc. The purpose of setting up statements is the economic transactions between the two parties. Accurate, the increase, decrease, and balance of each party are exactly the same. To do this work, you should pay attention to the following points:

1. The economic transactions must be registered item by item in the chronological order of occurrence. And indicate the registration date, content, amount, and person in charge;

2. When registering, you must pay attention to the accounting direction of increases and decreases. The increase will be recorded as an increase, the decrease will be recorded as a decrease, and the balance will be calculated at the same time

3. In this way, there will be no errors when both parties register simultaneously. If there is any discrepancy, it may be caused by "the bill is in transit". "In transit" means that one party has registered and the other party has not received the bill and has not registered. This is called "In transit", what kind of bill is registered by both parties and the amount is the same.

Question 3: How to make statements. Statements include statements between the unit and the bank, statements between the unit and related units, statements between the unit and individuals, etc. The purpose of setting up statements is for both parties. The economic transactions must be accurate, and the increases, decreases, and balances of both parties are correct. To do this work, you should pay attention to the following points:

1. The economic transactions must be made item by item in the chronological order of occurrence. Register, and indicate the registration date, content, amount, and person in charge;

2. When registering, you must pay attention to the accounting direction of increases and decreases. The increase will be recorded as an increase, the decrease will be recorded as a decrease, and the balance will be calculated at the same time.

3. In this way, there will be no errors when both parties register simultaneously. If there is any discrepancy, it may be caused by "the bill is in transit". "In transit" means that one party has registered and the other party has not received the bill and has not registered. It's called "in transit", and the amount of the bill registered by both parties is the same.

Question 4: How to make a statement sheet on a computer? You can use EXCEL to make it.

Question 5: How to make a statement of customer transactions? It is very simple. You can make it for each batch of purchases. With the order number,... list all the orders you have purchased so far this month, the order number, and the amount, and then correspond to the invoices you have received this month for payment, and then list the order numbers and the order numbers that have not yet been invoiced and are listed in the accounts payable. Just send the amount to the supplier for confirmation.,

Question 6: How to use spreadsheet to make the bill MICROSOFT EXCEL

Question 7: How to create the statement format and use Excel to make the statement Relatively simple and easy.

Method steps:

1. Open the Excel table, enter the title (name of the company) in the first row of the table, enter the address (detailed address of the company) in the second row, Enter the company's name on the third line (telephone and fax), enter the fourth line (statement), and enter the fifth line (customer, month, printing date).

2. Press and hold the "Ctrl" key on the keyboard, select the areas A1:H1,A2:H2,A3:H3,A4:H4,A5:H5, and click Merge and Center button key.

3. Select the area A6:H18, click the border button in the menu bar, and select all borders.

4. Enter the date, delivery order number, name and specifications, unit, quantity, unit price (yuan), amount (yuan), and remarks in the form. After inputting, press and hold " Hold down the "Ctrl" key, select the area A18:C18, D18:G18, and click the merge and center buttons in the menu bar.

5. Enter "total payment for this month (RMB) and RMB symbol" in the merged cells, and indicate the above matters below the table, account name (name of the company's payee) , Agricultural Bank of China account number, supplier confirmation, customer confirmation, and finally adjust the font size and format according to the content.

Note: When making a statement, please check the seats according to the delivery order.

Question 8: How to make a payment statement? Find a Geng-level accounting practice book and follow the table above. The main purpose is to adjust the difference between bank receipts and payments and the company's book receipts and payments, so that the adjusted bank deposits are consistent with the company's bank deposit account amount in the company's bank deposits. On the basis of the account book, subtract the unpaid amount paid by the enterprise and add the unpaid amount received by the enterprise. On the basis of the bank statement, subtract the unpaid amount paid by the enterprise and add the unpaid amount received by the enterprise.

Question 9: What are the accounting entries of the bank statement? Just make a bank reconciliation statement, there is no need to make accounting entries. One side is the bank statement, and the other side is the company's journal. The bank statement plus the amount collected by the company and not collected by the bank, minus the amount paid by the company and unpaid by the bank.

Add the increase on the journal side and subtract the unpaid amount (the principle is the same as the reconciliation). If the account is recorded correctly, the two sides can be reconciled.

Question 10: How to make statements and monthly reports in EXCEL 1. Open the Excel table, enter the title (name of the company) in the first row of the table, enter the address (detailed address of the company) in the second row, Enter the company's information (telephone and fax) on the third line, the statement (statement) on the fourth line, and the customer, month, printing date on the fifth line, as shown in the picture

2. Press and hold on the keyboard Hold the "Ctrl" key, select the areas A1:H1, A2:H2, A3:H3, A4:H4, A5:H5, and click the merge and center button in the menu bar

3.

Select the area A6:H18, click the border button in the menu bar, select all borders,

4.

Enter the date and delivery order number in the form , name and specification, unit, quantity, unit price (yuan), amount (yuan), remarks. After inputting, hold down the "Ctrl" key on the keyboard, select the area A18:C18,D18:G18, and click on the menu bar Press the merge and center buttons in

5.

Enter "Total payment for this month (RMB) and RMB symbol" respectively in the merged cells, and under the table Indicate the above matters, account name (name of company payee), Agricultural Bank of China account number, supplier confirmation, customer confirmation, as shown in the picture, and finally adjust the font size and format according to the content.

When making a statement, just check the seats according to the delivery order