How to enter data when the financial software of golden abacus establishes the total salary?

If you need to pay wages several times a month or according to the project, it is recommended that users prepare multiple payroll tables according to the time or project to facilitate the entry, modification and payment of wages.

1. Click the "Create Payroll" tab in the flowchart to enter the "Add Payroll" wizard dialog box. Enter the name and creation date of the payroll;

2. Click "Next" and select the data source of this salary payment in the "Data Source" page; 3. Click "Next" and set the salary payment items in the "Payment Items" page.

By moving the button, you can select the required item in the Salary Item of Current Payment list; By moving the button up and down, you can sort the selected salary items at will.

4. To add a new salary item, click Add to open the Add Salary Item dialog box. Just enter a new salary item.

5. Click the "Next" button to set the clear item flag. 6. Click Next to select the person who will pay the salary.

7. Click "Next" and set the calculation formula for this salary payment on the "Calculation Formula" page.

(1) Click "Add Formula" and select the items to be calculated in the "Calculation Item" column (such as "Total Payable" and "Total Paid");

(2) Define a calculation expression in the "Calculation Formula" column. If the expression involves a salary item, please select it in the Item list box; If non-wage content is involved, such as "22.5", you can directly enter it in the calculation formula column and connect it in series with four operators (addition, subtraction, multiplication and division);

Users can automatically generate expressions to find the number of people, total number, maximum value, minimum value and average value in the calculation formula through the function wizard. For example, according to this function wizard, the calculation formula of managers' bonus based on the average bonus of production workers can be generated.

Click the Function Wizard button to open the Calculate Function dialog box.

Select the salary item to be calculated in Calculation Item; Select the required function in the function type; Select the range to participate in this calculation in the project list, and click OK to automatically generate the average function.

(3) Determine the applicable scope of the formula in the calculation range, select the corresponding condition names in the item column and connect them in series with logical operators (symbols other than the four operators). If there are detailed items involved, such as employee names, the corresponding contents will be displayed in the list of values box, and you can make more specific choices.

(4) If zero deduction is required, please tick "Zero Deduction Calculation" to open the "Zero Deduction Settings" dialog box. Select zero deduction standard and zero deduction item, and the system will automatically list the calculation formula of this zero deduction according to this setting.

(5) If tax deduction calculation is required, please mark "Tax Deduction Calculation" in the pop-up window and select the corresponding tax deduction item.

8. Click Next to set the calculation length formula of this salary payment. 9. Click Finish to generate payroll.

Wage entry

Payroll entry

1. After adding payroll, click "Finish" and the system will automatically enter the payroll entry window. You can also click the "Salary Entry" icon in the flow chart to enter the "Salary Data Entry" window.

2. In this window, the system lists the name of the current total salary and specific salary items. You can select the total salary to be entered, and then enter the corresponding salary data in the corresponding salary column.

3. Mark the column "Automatic Calculation". Once the data of the basic project is entered, the system will calculate the data of the calculation project in time. ? Column setting

For salary items that change frequently, you can enter them centrally through column settings.

1. Click Edit and select Column Settings to open the Column Settings dialog box. 2. Select the salary item to be entered this time from the "Optional Column" list;

3. Enter the name of the salary entry in Column Setting Name;

4. Click "Save Settings" to save the currently set columns for future use;

5. Click OK to return to the salary data entry window, and the items listed in the salary data entry window are the newly set entry items;

6. In the "Entry Item" column of the "Salary Data Entry" window, the various entry item settings you set for the current salary will be listed, and you can select them as needed every time you enter.

Batch modification

Use the batch modification function of this system to modify data in batches. Details are as follows: 1. Click the Edit button, select the batch modification item and enter the batch modification dialog box. 2. Select the salary item to be modified in the "Modified Item" column.

3. In the "Modify to" edit box, you can directly enter a number, select the salary items listed at the bottom of the window, and use four expressions between salary items.

4. If you need to reference the salary item data of other salary tables for calculation, you can first select the required salary table in the "Reference" column, and then select the required salary item.

5. If the range of batch modification is not all employees, you can enter the range of this batch modification in "Modification Range". 6. Click "Formula Verification" button, and the system will automatically check the legality of batch modification of formulas.

7. Click < b > OK , and the modified items in the payroll will be automatically adjusted according to the set batch modification formula. ? lock

If you need to enter a salary item for all employees before entering the next salary item, you can use the locking function. 1. Move the cursor to the salary item to be locked, click the edit button (or the right mouse button), and select the "Lock ××××" item. The salary item will be locked, and you can only enter data in this column.

2. After entering this column, click the "Edit" button and select "Unlock" to enter other items. ? Salary distribution table

After the payroll is entered, you can use the payroll distribution table to calculate the number of banknotes with different denominations needed to pay the salary.

1. Click the "Report" button in the salary distribution directory window and select "Pay Table Wizard" to open the "Pay Table Wizard" dialog box. 2 determine the name of the report, the source of total wages, distribution items and distribution standards. 3. Click Next to set the query item. 4. Click Next to set the report query criteria.

5. Click "Next" to select the contents of the header column, and finally click "Finish" to automatically calculate the detailed allocation data according to the selected payroll and setting conditions.

Query and print payroll

After entering salary data, you can consult various salary reports and print them out. For example, salary payment table, salary payment slip, salary summary table, salary distribution table, personal income tax withholding declaration form, etc.

Payroll query

The system provides three ways to enter salary query:

1. Click the "Report" button in the "Salary Paying Directory" list to query the corresponding salary table;

2. In the tree menu, you can directly query the payroll, such as payroll, payroll summary, payroll paid by the bank, personal income tax withholding declaration form, employee payroll ledger, etc.

3. Click < b > Salary in the account table menu to enter the account table resource manager, or you can query the corresponding salary table; ? Payroll setup and printing

You can enter the Payroll window through the three methods mentioned above. 1. Click Payroll Setup to open the Payroll Setup Wizard dialog box. 2. It is necessary to determine the name of the report and the source of the data.

3. Click "Next" to select the query content of the payslip.

4. Click Next to select specific query criteria. Finally, click "Finish" to get the eligible payslip data. ? Financial synergy function

In the Payroll window, you can automatically send employee salary information through BIM, email or SMS. Sending method: you can choose email, instant messaging or SMS.

Open the payslip window, select the sending method and the employee payslip to send, and click the "Send" button. If the prompt is sent successfully, the payroll information will be sent successfully.

The bank pays wages on behalf of others.

If your salary is paid through the bank, you can set the format of the bank's salary payment file according to the requirements of the bank's salary payment file and generate the corresponding text file.

1. In the payroll directory list, first select the payroll table to generate payroll file, then click the report button, and select the item "Bank Payroll File" to enter the "Bank Payroll Format Settings" dialog box.

2. The names of banks involved in all employee cards are listed in the "Paying Bank" drop-down menu, and you can choose as needed. The company number refers to a number assigned to the company by the issuing bank, which is determined by the issuing bank.

Documents issued by banks refer to the names of documents issued by banks, which shall be determined by banks. Click the browse button in this column to specify the path to the build file. If no path is specified, the system will automatically default to the path where the system is located.

3. Click "Next" to select the payroll for which files need to be generated. 4. Click "Next" to set the data record format of the forwarded file.

Title name refers to the title bar name after the file is generated, which can be any character or empty;

Data source: refers to the basis for fetching data in this column. In addition to all salary items, the system also provides company name, employee name, bank account number and other information.

Type: including three types: number, date and text. If the type is number, you can specify the number of decimal places. Column width: the required length of each column is stipulated by the bank;

Output Decimal Point: refers to whether decimal points are required for generated documents issued by banks. If No is selected, the amount column in the bank payment file has no decimal point, and the last two digits are decimal places by default; If "Yes" is selected, the amount column in the document issued by the bank has a decimal point;

Complete characters: enter corresponding characters according to the requirements of the issuing bank;

Complement method: when the data width is less than the column width, it is filled with complete characters. The system provides three filling methods: left, right and both sides, which can be selected according to the requirements of the bank.

You can use the Move button to adjust the order of data in the forwarded file. 5. Click Next to set the format of the first and last record.

6. Click "Next" to enter the data preview window, where you can view the document content generated by the system according to the settings in the previous steps to determine whether it meets the specific regulations of the bank.

7. Click "Finish", the file name of the issuing bank will be generated according to the designed format, and the issuing format of the issuing bank will be saved.

Wage voucher

After the salary is paid, the salary expenses shall be allocated to the corresponding costs and expenses. 1. Click the "salary voucher" icon in the flow chart to enter the salary voucher wizard.

2. First, determine the accounting period of the payroll for which vouchers need to be generated, and mark the selected payroll with a selection mark. 3. Click Next to filter the filter conditions of this voucher.

4. Click Next to set the carry-forward name and calculation formula of salary voucher on the Calculation Formula page. 5. After setting the calculation formula, you need to set the debit and credit account of the voucher, and click Next to set the corresponding account. 6. Click "Next" to view the list of vouchers set according to your needs. Here, you can also select the template and type of the voucher and enter a simple summary. Click "Finish" button to generate the voucher.

Salary import plug-in

In order to enable users to import salary data in EXCEL, text, database tables and other file formats into the payroll of this system, the system provides the function of "Salary Import" in the "Plug-in" menu. The use of this function requires the current operator to have the permission of "Import and Export".

1. Select "Salary Import" to enter the "Salary Data Interface" wizard. 2. Select a data file

First, determine the file type of the salary file to be imported. The system supports multiple file formats.

(1) When the selected file type has a hierarchical structure (such as Excel file, universal table file of golden abacus, etc.). ), you also need to specify the name of the related Worksheet in the Select Table column.

(2) When the Text file is selected as the Type, you need to specify the delimiter of each column in the related file in the Delimiter Method. The separators provided by the system include tab separator, comma separator, semicolon separator, space separator, single vertical line separator, single quotation mark separator and user-defined separator. If "Custom Delimiter" is selected, the subsequent "Custom" input box is available, otherwise no information can be entered in this column.

(3) When the Type column selects other file types that do not need to specify the delimiter mode, the Delimiter Mode item cannot be used. After selecting the file type, you need to specify the path and file name of the file to be imported in the file column, or use the browse button after the file column to select the file to be imported. The system will filter the qualified files according to the selected type.

3. Set the correspondence relationship, which corresponds the information in the salary data to be imported to the salary table of a month in the specified fiscal year in the system. 4. Import salary data

After completing the above wizard settings, click "Finish" to start importing salary data into the specified salary table. 5. After the import is completed, a prompt will be given, telling the operator that the operation of importing salary data this time is "XX records imported successfully, YY records imported failed".

Receivable voucher

For the entered A/R documents, corresponding A/R vouchers need to be generated and entered into financial accounts to ensure data consistency. 1. Click the voucher receivable icon in the flow chart to enter the voucher receivable wizard dialog box. 2. Select the document type.

3. Click "Next" to select the A/R document to generate vouchers this time, and tick "√". Click Associate to query specific documents.

4. Click Next, and on the voucher setting page, select the template and voucher category for generating receivable vouchers, and set the summary (you can enter directly or select options to generate).

5. Click Next, select a voucher generation method, and then click Finish to generate a receivable voucher as needed.