How to use Excel for invoicing management 10

Will you VB?

If you can, you can use the Excel VB machine to write the functional program you need.

If you don't, you can consider using data association to use data association between multiple ** for purchase and sale management.

For example: to create **purchased,** fields are set according to your requirements (such as, product name, specification, **business, purchase price), sales table, and also according to the fields to set the required items, outbound table, income statement. In this way, the process of purchase, sale and inventory is basically completed.

Simple statistics can be done.

If you want to be more functional, then make a few more tables. At the same time, you can also analyze your next purchase plan through ** data. For example, sort the highest outbound goods and the lowest outbound goods by day; Comparing the frequency of shipments, you can use the data to generate a bar chart, which can be used to facilitate viewing and analysis, and can be used as a table.

Monthly, quarterly, semi-annual, and annual plans are the same as data statistics, and you can decide for yourself!

If a more detailed answer is needed; Please buy an Excel case book to read. It will be mentioned inside.

Actually, it's easier to do it with access. Please refer to the relevant books for specific questions!

What is your main purpose, we will only know how to explain it.

ok?Got it?

The steps to do BAI are as follows:

du1.Lose zhi in the first line

Incoming item name, date, DAO outbound, warehousing, and balance letter interest. As shown in the figure:

2.Use the formula for the balance = Quantity of storage + Number of storage + ...- Number of outbounds - Number of outbounds...., enter the formula and click the enter key. The following items can be generated by dragging down the lower left corner of the calculated balance cell.

Note: As long as the general warehouse warehousing list clearly writes the material name and warehousing and other information, it can be clear at a glance, and the purpose of making an inventory table has been achieved.

Now I still use excel to do purchase, sale and inventory copying, which is a bit backward. In the past, ordinary purchase, sale and inventory were not expensive, and it was not suitable for small and medium-sized businesses.

However, now with the development of technology and the emergence of mobile invoicing, there are many free invoicing software like Qin Si, which is simple to operate and easy to use, and the functions are even richer and more practical than excel, and it will be more intelligent, so many people are now switching to invoicing software.

As far as I know, there are almost no Excel in the wholesale market anymore.

1. First of all, it is necessary to establish the most basic three "coding tables", "journal accounts" and "inventory tables".

It takes a lot of care to make a coding table, and it is one of the most important things to ensure the accuracy of the accounting data.

2. According to the code classification, the warehouse materials are coded one by one.

3. With encoding, based on the "encoding table" that has been made, it is substituted with a function to make it more updated with the update of the encoding table.

Enter =vlookup(h2, [encoding table] in a2. xls]!a2：2000,2,0)

4. After a similar account is made, an "inventory table" is established

Enter in "Inbound".

Enter it in the "Outbound" field.

Then a simple inventory account with automatic calculation of purchase, sale and inventory along with the journal is established.

Wearing two watches, how do you know the time?