Importing Credit Card Transactions and auto calculate GST portion

I am new to importing credit card transactions and trying to figure out how you can automatically account for the GST portion of a purchase without manually manipulating every line item thru the general journal. I have been playing with match transactions but it will only assign the entire amount to an expense account. For example: if I have a $152.25 charge I would like it to automatically put $145 to a defined expense account and the other to GST paid on purchases. I am using Sage 50 Pro 2023 Canadian Addition.

Thanks in advance.

  • 0

    I found the importation of credit card statements to be main pain staking than doing an excel and then inputting manually.  Just my opinion though 

  • 0

    actually when you do you manual match you can use find match (drop down box appears) create transaction general journal enter your source which will be statement then your defined account then click more details.  Here you can change information.  You enter the before tax amount to defined account then below your bank entry you can enter your tax account (HST payable).  This does go to the gl for you.  However this way can be very tedious and time consuming.