Import Expense Transactions Feature

The 'Import Time' Tab located under Tools - Import,  is 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 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 Time.
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.

axis_support@tpssoftware.com    

Toll-free: 1- 888-877-2231

0 Votes