I need a template for an EXCEL Inbound, Outbound, Inventory or Inventory form that will automatically calculate when data is entered. Can send me a copy of it, thank you!

With the form is too much trouble, not a problem okay, a problem and have to find someone to solve, there may be inside the data is also lost, too insecure. Use a software, Zaiyi inventory management software is good, although the beginning of the point of money, but after that is a lifetime of free use, this is not like the type of product, is not bad, even if the problem, after-sales service is also free for life

You can go to the website to download a free trial

The Zaiyi inventory management software is mainly divided into sales management, purchasing management, warehouse management, financial management. Basic information, system settings (rights management) six major features include:

Basic information:

Customer information, supplier information, employee information, commodity information, company information, category maintenance.

Cost price Support the use of specified unit price method, moving weighted average method

Purchase Management:

Purchase Receipt, you can view the status of uncollected payment, you can drink directly to the purchase order to receive the goods, can be convenient to track the payment of each receipt. Every purchase, the cost price will be automatically calculated in accordance with the moving weighted average method.

Purchase Returns:Purchase returns can be referenced to purchase receipts, which will automatically reduce the amount due.

Purchase Payment Order: You can refer to the Purchase Receipt to make payment, or you can make prepayment directly to the supplier.

Sales Management:

Sales Billing (Shipping Order): After billing, inventory is reduced and can be used as a delivery order. Automatically generate receivables, you can easily track the collection of each sales billing, you can set the tax rate, and automatically display the profit, profit margin and other parameters.

Sales billing can automatically refer to the customer's previous sales records sales.

Sales order tracking to understand the implementation of each order.

Sales bill, you can view the uncollected payment, you can drink directly from the sales order receipt, you can easily track the collection of each sales billing, you can set the tax rate, and automatically display the profit, profit margin and other parameters.

Sales return orders can be referenced to the sales order.

Cash sales: direct sales out of the warehouse, inventory reduction, and collect the customer's payment, does not generate the outstanding amount.

Warehouse Management:

Receiving material out of stock, return material into stock, product into stock, material requisition, inventory count, inventory scrapping, warehouse transfer, borrowing, lending, borrowing back out, borrowing back in, supplier customer information management, supplier supply summary, detailed reports.

Money flow management financial functions:

Costs and expenses: you can do the reimbursement, a record of office expenses.

Other income: you can record some sales other than the income statement.

Bank deposits and withdrawals: record bank deposits and withdrawals

Accounts receivable management: for sales billing will automatically generate accounts receivable, you can do a batch of billing, you can also be a single sales billing for collection.

Accounts payable management: for the purchase of goods received, will automatically generate accounts payable, support for batch order collection.

You can always know the status of funds, the status of funds on each bank account.

System Management:

Operator Management: You can add operators with different roles such as salesman, administrator, boss, manager and so on.

Database backup and recovery, set passwords, system logs and so on.

Operation Analysis:

Inventory Analysis: Inventory Summary Table, Inventory Detail Table, Departmental Consumption Summary, Detailed Report, Warehouse Summary, Detailed Report

Sales Analysis: Gross Profit Summary, Sales Detailed Report, Sales Yearly Report and other reports, Sales Profit Analysis, Purchase Payment Summary, Detailed Report.

Purchase analysis: customer supply summary, detailed reports, customer payment summary, detailed reports, so that the company's business at a glance.

Three exclusive features:

1. Inventory inventory, support for automatic inventory, support from Excel batch import inventory information exclusive.

2. When billing, support for importing commodity data information from Excel exclusive.

3. Unique order tracking function, support for batch order collection, batch order payment exclusive.

4. Perfect dual-unit processing function, you can set 1 piece = 12, you can enter 2 pieces of 3, automatically calculated as 27.

5. Commodity information settings: grouping and commodity information in the same interface, WYSIWYG tree interface exclusive.

6. Entry of product information, support for pinyin code, Chinese characters, codes and other fuzzy input mode, support for manual search input mode, support for bar code scanning mode exclusive.

7. Numerous custom features, customize the form entry interface, customize the display interface exclusive.

8. Free combination of settings query combination conditions query exclusive.

9. The only one truly available import function, the initialization can be very easy to import product information, customer information.

10. You can set your own document number format, customer code, commodity code format.

10. You can set your own document number format, customer code, commodity code format.