Import Expense Transactions Feature

The 'Import Expenses' Tab located under Tools - Import,  is specifically designed to simplify the way you handle monthly expenses, especially when dealing with recurring transactions like monthly subscription fees for various services that may vary in expense amount every month. One of the standout benefits of this enhanced import functionality is the ease with which accounting firms can upload expense transactions and seamlessly mange them in the time entry screen,  subsequently incorporating them into the billing process.

Key Highlights:

• Efficient Expense Entries: This tool provides a seamless way to import expense entries directly from an Excel spreadsheet, ensuring accuracy and saving valuable time.
• Excel Sample: To facilitate a smooth process, the feature comes equipped with pre-configured columns:
  • ClientID
    
  • WorkCode ID
    
    
  • Amount
  • Description (optional)
    
    
    

• Integration with Time Entry Screen:  After successfully importing expense entries, users can navigate to the Time Entry Screen to review and manage the associated transactions. The expenses will be assigned to the user who uploaded them and will be saved with the upload date, which is the current day.

It's crucial to note that the Import Tool is intentionally crafted exclusively for 'Expense transactions' and WILL NOT import any other type of transaction (CHG OR NONCHG). Also, Client ID's and Workcode ID's must be an exact match to what is in your database.  If there is any mis-match, the expense transaction WILL NOT be imported and you will get no warning of the mis-match.

To utilize this feature:

1. Access the main menu and choose 'Import' located under Tools -> Import -> Import Expenses.
2. Download the Excel 'Sample' spreadsheet and complete the necessary fields.
3. Confirm that the 'ClientID' and 'Workcode' match the database entries and 'Save' the file. Any record with an unrecognized Client ID or Workcode ID will not be imported.
4. Once completed, choose the file using the 'Choose File' option and initiate the 'Import' process.

5. Navigate to the 'Time Entry' screen to manage the expense transactions.

We are confident that this feature will enhance your overall experience with expenses.

axis_support@tpssoftware.com    

Toll-free: 1- 888-877-2231

0 Votes