Transaction Rules & Customer Payments

Transaction Rules & Customer Payments

So I have a situation as follows. We have many clients who are all invoiced on the 1st of each month on a recurring invoice for 1 of 10 plans.

This means that almost all payment dates are the same (some people pay late) and that a lot of the amounts are the same.

All payments are offline

This means that ZERO % of the time the Match works as it only seems to check date and amount.

All my customers pay using a reference number displayed on their invoice.

I wanted to create a "Transaction Rule" that matches a "Customer Payment", but that option is not available?

This means, the only way to Categorise a payment is to do it manually and search that reference number, find the customer and search for it again under "Categorise Manually". It is extremly time consuming & error prone. 

Is there any other solution?

    • Recent Topics

    • The ability to show fields from subforms when viewing from related list

      Hi there, Currently im only able to display default columns , however when im unable to add the columns/fields from the subform Ive created. below is a field called quantity from the subform. Im not able to search up this field from the manage column

    • Tip 26: How to hide the "Submit" button from a form

      Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in.  Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and then

    • Tip 31: How to make a field in a Zoho Creator form mandatory based on criteria

      Hi folks,   I'm sure most of you are familiar with the Mandatory property available in our form builder. It enables you to ensure that your users enter an input in a required field. If they don't enter an input in that field, they'll be unable to submit

    • Create a new module with first name & last name, and join the two when viewing records

      I've created a new module, and I have first name / last name fields (I've renamed the record name field as last name). When I'm viewing a record, I'd like to see "Bob Smith" at the top of the page and in lists, not just "Smith" as I have today - basically the same experience you get when editing / viewing leads in the leads module.

    • Display name in Zoho Desk Ticketing system

      We are in the trial phase to implement a Ticketing system. As our company uses several generic emails, such as service@abc.com and service@xyz.com across different branches, the uniqueness of usernames (full names) becomes crucial for our business. Without

    • Desk Contact Name > split to First and Last name

      I am new to Zoho and while setting up the Desk and Help Center, I saw that new tickets created or submitted from the Help Center used the Contact Name field. This would create a new Contact but put the person's name in the Last Name field only. The First

    • Time Entry warning

      Is it possible to configure a warning/alert when a ticket exceeds a set amount of Time?

    • Use color coding for picklist field values to enhance visual representation

      It's easier and more efficient to manage a large volume of data in a ticket or other custom module records, such as ticket priorities and issue types, when you apply clear visual distinctions through color coding. Color-coded picklist fields allow users

    • Kaizen #126 - Circuits in Zoho CRM - Part 1

      Hello everyone! Welcome back to another week of Kaizen! Today, we will discuss an exciting topic—Circuits in Zoho CRM. For starters, we will discuss what Circuits are, how beneficial they are for businesses, different views of a Circuit, and the different

    • How to Freeze Tasks

      Is there a way to freeze a task in the Gantt chart so it cannot move even when predecessors are moved?

    • Is it possible to have conditional pages?

      We have a Document, which consists of multiple different subdocuments. We want to have the subdocuments as pages inside a doc and only show them in specific cases. Is it possible to have conditional pages inside of a mail merge based on CRM data?

    • Campaigns workflow emails going to Spam

      Hi Everyone, Does anyone have a solution for workflow emails going to recipients SPAM folders? Our domain is not on any Blacklists, We have our domain authenticated with SPF, DKIM and DMARC all set up and we still have leads who tell us they are not getting

    • Re-send document that's in process

      I tried to send out a document for signature via Email & SMS. The email bounced and I didn't have any SMS credits, so that failed too. I now have SMS credits and want to re-send the same document to the same email address and phone number. How do I do

    • How to associate a document sent in Zoho Sign with an deal in the CRM?

      Hi, often documents are loaded in Zoho sign and sent for signature. These sometimes are linked to a deal in the Zoho CRM and would be nice to see the status of the document within the CRM. I am aware of the integration, but that assumes that the document

    • Zoho Mail Android app update - View emails shared via Permalink on the app.

      Hello everyone! In the latest version(v2.8.2) of the Zoho Mail Android app update, we have brought in support to access the emails shared via permalink within the app. Earlier, when you click the permalink of an email, you'll be redirected to a mobile

    • Partial payments for retainer invoices

      When a customer does not pay the entire retainer invoice there is no way to apply a partial payment. PLEASE add this function.

    • Continue after error for each loop on invoke url

      Hello. I'm trying to upload files to workdrive using invokeurl. It goes through a list of urls using for each. Sometimes the file is larger than 5mb. The whole workflow stops in that event. I'd love a work around to upload larger files, but I don't think

    • Expenses in multi organisatuon setup

      I appreciate that this question can be a mix of zoho expense and books. I have 2 books organisations, where one of them is only being used for financial management of a subsidiary in a separate country. Literally just for purpose of input accounting 

    • Help Center Help!

      Hello, I am fairly new to Zoho Desk and want to write articles and publish them on a Help Centre. However, I cannot wrap my head around how to get started. Can someone from Zoho do a one on one with me or are there helpful videos on this topic? Frustrated,

    • CRM

      I have a portal set up where a contact can see other contacts within an account automatically. When a contact in the portal enters a deal, how do I make sure that deal is assigned to the account so other contacts in the account can see the deal was generated?

    • Facing issue in getting data through api calls

      I have send data of users and want to get the data oof users but facing issue with one field for that I want help

    • Incorrect merging of two tickets: Delete Mail History

      Hello, I merged two different (incorrect) tickets in the Zoho Desk system. How can I remove the communication from the merged ticket?

    • Notebook stacks

      Hello, Are you planning to implement some kind of notebook grouping, similar to evernote stacks? I know that we can group notes inside of the particular notebook but for a lot of us it is not enough I belive. Sometimes that additional layer for organization

    • CRM Quotes- Delete tasks when status is changed

      Hello. We have our quotes setup for approval process. We would like however to delete the tasks that are made when a different quote stage is selected. So when a quote stage is setup for "sent for review" we have the automation process to send out an

    • Formatting Mailing Labels

      I want to use the "Print Mailing Labels" function on the drop down list, but I am not seeing a way to change the formatting on the mailing labels. At the moment, the information that appears on the mailing labels ARE NOT mailing addresses, but random information.  I would also like to change be able to change the size of the labels.  At the very least I would like to know what type of labels I can get that would be the correct size.  

    • Setting Up Auto-charges using payoneer as a gateway

      I use payoneer as my gateway because of my location, however, I have a new client who wants to be auto-charged every mont. Is this possible with the gateway I use? Or does the client have to manually pay every month?

    • Is there a way to show contact emails in the Account?

      I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail

    • Create CRM Notes from Creator using Deluge

      I sync our CRM with information from a Creator application using the zoho.crm.create and zoho.crm.updateRecord functions, passing in the appropriate Map variables. This is working fine. However, I'd like to be able to create Notes associated to CRM modules

    • Hourly Permission not getting Calculated

      That is our settings The total calculation should be from 9:37 AM to 3:37 PM, but the hourly permission isn't getting calculated The last entry is hourly permission, it's not

    • Custom widgets on Zoho one dashboard

      Is it possible to create custom widgets on the Zoho One dashboard? I see there is a widget name My Open Tickets to display open tickets in my view, but I would also like to have a widget to display unassigned tickets. A widget to display unfinished projects

    • When will Zoho MA have a feature to filter out bot clicks from actual human clicks?

      When will Zoho MA have a feature to filter out bot clicks from actual human clicks so that actual metrics aren't affected? How are we expected to differentiate it today?

    • Backup all report zoho creator

      I want to backup an unused form record. But some fields are not displayed in the list report, if I export in the list report it will not retrieve all fields in the form. Is there a quick way to backup all the fields in the form without having to display

    • Zoho ONE Inventory and Zoho FSM

      Zoho ONE Inventory sees a warehouse just as a warehouse. You have to be a ZOHO ONE usher for example to use a warehouse like counting stock while you have to buy a warehouse as an Add one separately from ZOHO ONE Inventory to use it for ZOHO FSM In ZOHO

    • Useful enhancements to Mail Merge in Zoho CRM

      Dear Customers, We hope you're well! We're here with a set of highly anticipated enhancements to the Mail Merge feature in Zoho CRM. Let's go! Mail Merge in Zoho CRM integrates with Zoho Writer to simplify the process of customizing and sharing documents

    • how to have incline alert on subrow's column or subform or other workaround that at least can let the user know this subform currently has some validation checking.

      I have a subform and each row that are some columns that are compulsory to fill up. If user did not fill up, how to show incline alert on those columns or incline alert on the subform. Or any workaround that at least can bring the user to that fields

    • Modify the default layout of how task fields are ordered in Project View

      Hi all, I am trying to change the order the columns on project List view when a project is created initially. See image below. Currently, when a project is created, a predefined collumns are created and also its orders. I am aware that I can "hide", and

    • Zoho CRM and Google Sync - delete Contacts?

      If I delete a contact in Zoho CRM, will it also be deleted in Google contacts?

    • Customer Segmentation using RFM Analysis

      How well do you know your customers? Whether you operate in a B2B or B2C space, chances are that 80% of your business comes from just 20% of your customers (Pareto's Principle).According to a study by Forbes, acquiring new customers costs five times more

    • Currency transition

      We are using Zoho CRM in Curacao, Dutch Caribbean. Our currency is currently the ANG. Curacao will be transition ing from using the ANG (Antillean Guilder) to using the XCG currency (Caribbean Guilder) on March 31st 2025, see: https://www.mcb-bank.com/caribbean-guilder.

    • Google Ads Data is Publicly available in Zoho CRM

      We recently discovered that ALL of the following Google Ads fields are visible to all users in our CRM that have access to either Leads or Contacts modules. Not only is this troubling and inconvenient, it should be unacceptable. It also creates a mess

    • Next Page