Posts Tagged ‘Treasurer’

Enhancements to Income & Expense Tracker

Fine Tuned

Fine Tuned

A bunch of enhancements have been released in the Accounting modules. Please share this update with your Office Staff in case they are responsible for Income/Expense Tracker data entry.

CHANGES IN INCOME TRACKER

1. Collection Screen

Path: Admin Dashboard > Income Tracker > Track Fees > Collection button

2 NEW fields have been introduced : Instrument type ( Cheque, NEFT, Cash, DD ) and Instrument Bank. These are mandatory fields and will help in complete data capture and reconciliation.

2. Online Receipt Changes

The Online Receipt will now show the period of  Auto Invoice (Maintenance Fee), against which the Collection has been applied. You dont have to enter the Period manually any more.

The Receipt generally looks more beautiful!

3. Batch Invoice posting screen & Excel Import of Invoices

Path: Admin Dashboard > Income Tracker > Track Fees > Post Invoice in Batch

Till now, while doing batch posting of Invoices or Excel Import of Invoices, you could provide only one posting Date, applicable to all Invoices in that Batch.

Now each Invoice entry can have its specific date. In case of Excel Import, the template now carries the Square Feet, Flat Category and open Dues for all the flats – this will help you in calculating Penalties based on your forumula ( eg. x% of open dues). This excel can then be uploaded to post the penalties.

4. Batch payment posting and Excel Import of payments

Path: Admin Dashboard > Income Tracker > Track Fees > Post Payment in Batch

Instrument Type, Instrument Bank and Instrument Date are the new fields available for each payment. Also, in the Excel template the open Dues, Flat Category and Square Feet is exposed.

Note : Please make sure the final excel you are uploading is in CSV format.

CHANGES IN EXPENSE TRACKER

1. Payment screen changes

Path: Admin Dashboard > Expense Tracker > Post Expense > Make Payment button

1 NEW field have been introduced : Instrument type ( Cheque, NEFT, Cash, DD ). This is a mandatory field and will help in complete data capture and reconciliation.

CHANGES IN INCOME TRACKER & EXPENSE TRACKER

1. Removing Auto-Reconcile from posting screens

The Auto-Reconcile feature has not lived up to its expectation of usefulness. It has been voted down by our Product Mgmt Team and User Focus group, and is being removed. For regular reconciliation, please go to the Bank & Cash application for easy and quick, albeit manual reconciling of transactions.

That’s it for this Release, watch out for more cool enhancements to your favorite Applications.

Wishing you a great second Quarter!

ApartmentAdda Team

Welcoming April-2010 with Service Tax, Tally Integration and more!

The Tech team of ApartmentAdda has been burning gallons of midnight oil collating the Accounting related inputs from customers,and running through them with reputed Apartment Auditors.

The latest release of ApartmentAdda carries with it many upgrades on all the Accounting applications. Existing customers data have been migrated over the last two days.

Here are the highlights of this Release.

Adda Admin's view of Apartment Management!

Adda Admin's view of Apartment Management.

1. Apartment Categories

Introducing “Apartment Categories” in the Income Tracker. You can create categories e.g., 2BHK, 3BHK, Rented, Penthouse, Service Apartment etc. For each Category you can create an Invoicing rule  – assign different rate per square feet, or flat rate – depending on your setup.

Then you can classify each Apartment into one of the categories.

That’s All! Invoices will be automatically posted against each Apartment, at the beginning of the term ( monthly, quarterly, half-yearly or yearly ) based on the Category rule.

How to configure: Admin Dashboard > Income Tracker > Setup tab.  Populate the Category field, and the Category Rule accordingly.  Go to the ‘Track Flats’ tab and assign the Apartments to the respective Categories.

If you are already using Income Tracker, and need to create Categories, please select a Revision, provide the date from which the revision will be applicable (e.g., 01-04-2010), then populate the Category field. Automatic Invoices posted only from the applicable date will pick up the changes.

Change of Category

Lets say the owner decides to convert his unit into a Service Apartment. Just assign the Apartment to the new Category. Starting from the next Invoicing Term, the automatic invoice which ApartmentAdda will generate will take this into account. It is seamless.

2. Service Tax Calculation

In cases where Service Tax is charged on the Regular Invoice (Maintenance Fee), the Service Tax component gets  automatically generated on the Invoice. An additional line item now shows up for such Apartments which is a % of the maintenance fee posted. It is possible for an Adda to levy Service Tax on certain Category of Apartments only (e.g., Service Apartments).

How to configure: Admin Dashboard > Income Tracker > Setup. Populate the Service Tax percentage for the Apartment Category(s) that Service Tax is applicable to.

If you are already using Income Tracker, and need to populate the Service Tax field, please select a Revision, provide the date from which the revision will be applicable (e.g., 01-04-2010), then populate the Category field. Automatic Invoices posted only from the applicable date will pick up the changes.

3. Flexible Allocation of Incoming Payments

If there are multiple open invoices for an Apartment, and when the resident makes a payment – the amount can be distributed among the open invoices. This is an optional feature. If you don’t opt to use it, just post the payments via ‘Bulk posting’ and ApartmentAdda will automatically distribute the payment starting from the oldest to the latest invoice (FIFO – First-In-First-Out basis).

4. Payment Instrument Number is mandatory

While posting an Incoming Payment, there is a new field – for capturing Cheque Number or NEFT’s reference number – in addition to the Comments field. This will help in automatic reconciliation. Something to make your Auditor happy!

5. Complete provision for Tally Integration

The much awaited gateway is now open! Now all transactions captured in ApartmentAdda can be ported to Tally, and vice-versa!  However, the decision to use or not use Tally along with ApartmentAdda, or the strategy of its use still remains your call!  Please read this post to understand how best to utilize ApartmentAdda Accounting.

Import of Dues and Payments from Excel

Earlier one could import the Dues against the Apartments, but incoming payments had to be posted individually against the Apartments. With this release the Incoming Payment postings can also be uploaded from Excel. Using this feature, the Dues and Collections posted in Tally can be easily imported into ApartmentAdda. This feature enables you to use Income Tracker solely as a Billing interface, in case you wish to continue with Tally as the Point of Origin of transactions.

Export of Dues and Payments to Excel

In Bank & Cash Application an additional tab has been enabled – called “Dues and Payments”. Here you can choose the account heads  from Resident Income, Miscellaneous Income and Expenses, choose the date range – and get all the dues and payment transactions on Excel. This includes Accounts Receivables as well as Payables. This can be exported to excel for further analysis or to be imported into Tally. Also, you can now answer some queries like :

What is the total service tax that has to be collected?
What is the total amount collected under Festival Funds?
What are all the transactions ( both Income and Expense ) pertaining to Project X?

Miscellaneous  Enhancements

Archive “I have paid intimations”: Now after you have posted a transaction based on the intimation from the resident, you can archive them for future reference by either Accepting or Rejecting it – and you have the option of entering comments.

Performance Improvements: The Income tracker pages will now load faster than ever, and any changes to setup, track flats – will also happen much faster.

With this, we hope we have equipped you for the coming Financial year !

Yours sincerely,
ApartmentAdda Team !

PS: Our sincere thanks to Anju Pruthi, Guruprasad Pandit and Prestige Langleigh for helping us raise the bar!

Why use the ApartmentAdda Accounting Package

What are the Financial transactions that Multi Dwelling Units (Apartment/Villa communities) perform?

1. Invoicing Residents

2. Collecting Payments from Residents

3. Receiving Vendor Invoices

4. Making payments to Vendors

5. Investing Funds

6. Collection and payment of Taxes

7. Adjustment Entries – Write-Offs, Depreciation and others.

What does ApartmentAdda Accounting offer?

1. Complete Billing and Collection module, with provision for Service Tax.  Online Invoices and Receipts are interfaced with Residents who are the users of ApartmentAdda. Invoices and Receipts sent via Email and SMS.

2. Complete capture of Vendor Invoices (Payables) and Payments made, by Expense Heads. Expenses can be published to Residents with a single click.

3. Complete Online Cash Position report, reconciliation function with Bank Statement, download to Excel for further analysis, audit or porting to other Accounting Packages.

“This typically takes care of 95% of the Accounting requirements of an MDU.” – Apartment Auditor

These transactions can be exported to Excel with single click, to be converted to the Final Accounting Statements, after adding other derived components such as Asset Depreciation and other Adjustment Entries.

Accounting Apps

Advantage of using ApartmentAdda Accounting for all Invoicing and Collection:

1. Online. Invoices are always accessible to the Residents. Integration with Email and SMS is a tremendous accelerator for quick collection.

2. Automatic Invoice generation for Maintenance Fee – not available in any other Accounting Package.

3. Ease of transaction entry – does not need an Accountant to operate.