Wednesday, August 29, 2012

Booking Rent expense with TDS

In our daily accounting, we do lot of accrual expenses i.e.rent, salary etc..  How do we do it in AccountingGuru?  AccountingGuru made it so easy.  Let us  see how we do a rent expense in AccountingGuru.

Go to Accounting -> Expenses -> New Accrual Expense


The following screen appears when you do the above


Just feed in the following

  1. Date
  2. Due date
  3. Comments (Mandatory)
  4. Expense type (i.e.Rent)
  5. Amount
  6. To -> whom you are paying


Click on “Create”

When it is created successfully, it says “Created Accrual expense successfully”


When we make a payment of Rent, salary etc.. we deduct 10% of TDS from the actual rent and pay the balance to the Owner or Employee.  In this case,  Rent is Rs.10000.00 and the TDS amount would be 10% of the rent is Rs.1000.00.  Let us see how do we do it in AccountingGuru.

Click on “New Tds Payable” 


When you click on “New Tds Payable” the below screen appears

  1. Select the date
  2. Select the Recipient (Company or Non-company)
  3. Section

  • Below are the few important TDS section codes for your easy set up of TDS sections


Section
Nature of Payment
Code
192
Payment to Govt. Employees other than Union Government Employees
9
2
A
192
Payment of Employees other that Govt.Employees
9
2
B
193
Interest on Securities
1
9
3
194
Dividend
1
9
4
194A
Interest other than interest on securities
9
4
A
194C
Payment of contractors and sub-contractors
9
4
C
194EE
Payments in respect of Deposits under National Savings Scheme
4
E
E
194F
Payments on account of Re-purchase of Units by Mutual Funds or UTI
9
4
F
194H
Commission on Brokerage
9
4
H
194I
Rent
9
4
I
194J
Fees for Professional or Technical Services
9
4
J
194LA
Payment of Compensation on acquisition of certain immovable property
9
4
L
195
Other sums payable to a non-resident
1
9
5

To create a TDS section Click on “Create New TDS Section” as shown below


When you click on “Create New TDS Section”, a pop-up window opens.  Feed in the Section as shown below and click on “Create”


New TDS section is created.
      Ø      Type in your comments and ref no.
Ø      Click on the check box to select it.
Ø      Feed in the %.  TDS is 10%.  When you feed in the percentage, it automatically calculates the actual amount of TDS
Ø Click on “Approve”

On successful creation, the follow screen appears and says “TDS payable created successfully”


Click on   Back to Accrual Expenses 


The below screen appears

When you want to make the payment, click on “Make Payment”


The below screen appears.
      Ø      Select the date
Ø      Payment Mode
Ø      Transaction number if you have anything
Ø      Comments i.e, cheque number, bank name etc…
Ø      Confirm the check box is selected
Ø      Click on “Create”


On Successful creation, below screen appears and says “ Payment created successfully”


If there is any modification to be done, Click on “ Modify ”.  After doing the changes click on “ Update ”
_________________________________________________________________________________

Friday, August 17, 2012

Export data to Tally from AccountingGuru

A New feature that enables you to download the data from AccountingGuru and upload it into Tally!!!

Why Export To Tally?


AccountingGuru combined with Tally is a powerful combination that enhances the productivity of accounting professionals.
  1. Through AccountingGuru, accounting professional can enter the data anywhere and anytime
  2. Customers can view the data offline using Tally.
  3. Till date, Accounting Professionals are more familiar with Tally than any other software. Hence, they can view/modify the data and suggest changes to the client.
AccountingGuru made it so simple!!!

Open your company in AccountingGuru,

  • Click on Settings -> Tally Export -> Next


When you do the above, you will be directed to the ledgers page.  You will be able to see all your ledgers.  Now, perform the mapping for AccountingGuru Ledger to Tally Groups and Sub-groups. This exercise is done only for the 1st time when you export your data to Tally.


Please assign the Tally Group and the Sub-group for the AccountingGuru ledgers using the drop-down menu under the tab "Tally Group" and click on "Export"



When you clicked on "Export", the "Masters" & "Transactions" files will be sent to your E-mail.  These files are ".csv" files.  These files need to be converted into a normal "Excel" files.

To convert the files just follow the below steps.
  • Download the files from your E-mail and save it into your system
  • Open the file and click on File -> Save As...

When you click on "Save As..." a pop-up window opens.  Leave the File name as it is.  
Click on Save As type drop down menu and select "Microsoft Excel" and click on "Save"


You have successfully converted the ".csv" to "Excel" file.

Convert both the files as "Excel" and save into your system.

Now, the Ist part is done and your AccountingGuru data is ready to be put into TALLY.

For detailed instructions on how to get the data from AccountingGuru, please view our user guide.

The IInd part is uploading the data to Tally.

Before doing it, send your TALLY License Number to AccountingGuru and get the TCP file.

Now follow the instructions.
  1. Open Tally.ERP 9 and Load the Company.
  2. Load the Integration.tcp to Tally ( One time only)
  3.  Process to install TCP file
     I.  Gateway of Tally -> F12 Configurations ->  TDL Configurations -> Press F4 or Click on Local TDLs Button from the current Screen
     II.   Specify the TCP path

Setting up Transaction Types (one time)
        1.      After successful installation of Tally Extension file, do the below process to automate the default integration setup
        2.      Select Gateway of Tally -> F11 Features -> AccountsGuru Setup 


When you click on AccountsGuru Setup, it will be displayed that "All masters set up Successfully completed"

Process to import the Data


Master Data Import

    1.     Download the Master Data from AccountsGuru website and save into local folder
    2.     Select Gateway of Tally -> AccountsGuru Integration -> Masters

     3.   Now, Specify the below details.
          i) Import File Name(XLS)  : Path of the Master Data file which is saved from  
                                                             Accounts Guru website
         ii) Import Sheet Name         : Sheet name of the Master Data excel where data is 
                                                              presented

     4.   After Accepting  the above screen, on successful import of new master data, it will 
         be displayed that " Ledgers Imported Successfully"

If the version is not compatible with curent installed TCP, it will be displayed that "Incompatible Version!!!  Kindly download new version from AccountsGuru website"

     6. Once the data is imported,  Kindly configure the Tax related information in Tally.ERP 9
               Ex:

Transaction Data Import

    2.  Select Gateway of Tally -> AccountsGuru Integration -> Vouchers
and follow the above instructions.

For detailed instructions, view our userguide.