fast2022

[fast2022]

Use formulas in Excel spreadsheets

Excel formulas allow you to magically import Excel data. Simply map the columns of your existing Excel spreadsheet to the EA4 template. No other changes need to be made. You can import calculated data while mapping a sheet with an EA4 template using Excel formulas for column names.

The following table shows how formulas are best used when loading data into a template.

Excel Formula

Importing computed columns is feasible.

=a1*12.5/100

The value may be taken from one or more source sheet columns.

=(a1-b1+c1) *12.5/100

import of conditional values from the source sheet

=if(a1>0,c1,d1)

To obtain a computed string column, use formulas.

Bill number: & d1

Rounding to two decimal places

=round(a1,2)

Using the most recently used cell, automatically populate vacant columns

Possible using “Go to special” option with select “Blanks” command

Use a relative address and an absolute cell to calculate. Each cell will have the value of cell b100 added.

=a1+b100

Getting value using the offset formula

=Offset(a1,0,-1)

For absolute addresses, use the sum formula.

=SUM(“A1:D1”)

Using the relative address sum formula

=SUM(“A1:D1”)

Notes on importing data from source sheet to EazyAUTO4 template using formulas

1 Use “#” for relative row numbers like a#,b#…

2 Use absolute cell addresses like A10, and B25… to calculate using absolute addresses…

3 DO NOT start WITH ‘=’ sign

Get Excel To Tally Software

[fast2022]

Tally costs and cost center types

The term "cost center" in Tally.ERP 9 can refer to the organizational unit to which the costs or expenses of a transaction belong. On the other hand, the term "cost category" is used to accumulate the costs or benefits of a parallel set of cost centers.

Main categories of cost centers

The two basic categories of cost centers are:

A cost center associated with manufacturing or where goods are manufactured or processed. The assembly area is one example.

Performance-related cost centers are where services are provided to other cost centers. The canteen and human resources department serve as the clearest examples of our understanding.

Receipts can be used to specify cost centers. Activate the cost center for the G/L account used for document posting.

Cost Center Applied to Ledger Account

Cost centers must be assigned to G/L accounts

For example, activate the Freight Account cost center in the payment register.

Log in to Tally Gateway and select Account Info > Ledger. create/modify

Select Yes, cost centers apply.

Cost center assignment in document entry

The cost center assignment must be done in the pop-up sub-screen of the primary receipt entry screen. Amount fields for ledgers that have cost centers enabled appear after the chart. So the tile for Ledger Conveyor A/c looks like this:

The allocation of costs and revenues to cost centers is the only goal of cost center creation. After specifying the cost center, the payment slip entry page appears.

Get Excel To Tally Software

[fast2022]

Rewriting company data

If the Tally.ERP 9 data is corrupted, rewriting the data will help restore the original data.

If your business data is corrupted, you may receive one of the following error messages:

Error Manager.900, Link.900 or Tran.900

file, size, position, character, error code

memory access violation

Location error while debugging

Corrupted data file. need to rewrite

corrupted file

To rewrite company data

Open Company Information. Or the Tally Gateway menu.

Press Ctrl+Alt+R. The Company Rewrite screen displays a list of companies as shown below.

Decide which company you want to change the data for. Press Enter to update the data.

After the rewriting process is completed, you can access the recovered data.

Rewrite null command

If the error persists, try rewriting the null command. Always make a backup of your current data before performing this action.

On your Microsoft Windows computer, go to the Start menu.

Select Run and type Tally.exe, File Path > and Data Path > 0 in the space provided. For example, data 0 in C:Tally.ERP9Tally.exe would appear as:

Click OK. A tally gateway is displayed.

Press Ctrl+Alt+R. The Company Rewrite screen displays a list of companies as shown below.

Decide which company will rewrite the data.

Press Enter to update the data.

Get Excel to Tally Software

[fast2022]

Bank statement format in Excel

There are two types of Excel templates that can be used dynamically to import bank statements from Excel into Tally.

Account Statement – ​​Double Row

Bank Statement - 1 column

Information that must be displayed

The name of the sheet should be "Bank".

Sheet headers must match the two template types provided.

Do not change the header name, capitalization, and spaces.

Header and data validation

Required column

The date must be in date format and is a required column.

Details or descriptions are written information based on the information in your account statement.

The amount must be numeric and cannot contain a minus sign. LedgerName Specify according to the ledger name required for aggregation.

optional column

AccountName is the ledger used to reconcile bank statements after import.

You can include comments and additional information as needed.

Chq No, you can use any reference or space.

Optionally enter a BillName to link the invoice reference to the corresponding ledger. Optionally, enter CostCentre to map each cost center to its corresponding ledger.

Get Excel To Tally Software

[fast2022]

Tally ODBC with Microsoft Excel

Tally ODBC extracts data from Tally and creates reports in MS Excel. Here are the steps:

Enable ODBC in Tally

Start Tally and keep it open until the mail merge process is complete.

Make sure the ODBC server is displayed in Tally's calculator pane.

Open MS Excel.

On the menu, click Data > Get External Data > New Database Query. In the Select Data Source dialog box, select TallyODBC.

You can use the Filter Data dialog box to restrict the data as needed. In the Sort Order dialog box, sort the data in ascending or descending order. Click Finish to complete the query process.

To display the selected columns in the Excel sheet, click OK in the dialog box that appears after you import the external data back into Microsoft Excel.

Get Excel to Tally Software