As an entrepreneur, you need to keep a constant eye on both receipts and account transactions. In many cases, this is not so easy: account statements are saved in the online banking software, but invoices are created in a different program, so there is no relationship between the two databases.
Incoming payments often have to be laboriously recorded manually, often even in several applications or database systems. If a Interface If there are no data exchange systems, data exchange often involves the cumbersome and error-prone export and import of files. The CRM- and Merchandise management system gFM-Business brings both databases together: The software saves all receipts and can import account statements from other online banking programs to automatically identify and post payments. On the Mac, this is possible with the well-known banking programs Bank X and MacGiro - namely via the clipboard. In this article, we show you how to do it.
Account reconciliation and mark entries in bank X
Before bank statement entries are imported into gFM-Business Professional, an account reconciliation should first be carried out in the Bank X online banking software. The last previously imported account statement must then be found; this is the top entry in the gFM-Business account statement.
When importing for the first time, all entries in the account statement can be selected in Bank X. Once all the desired entries in the bank statement have been selected in Bank X, they are simply copied to the clipboard, either by using the key combination [cmd - c] or in the menu bar under [Edit > Copy].
Insert account statements in gFM-Business
If the desired entries from the account statement have been copied to the clipboard, they can be imported directly into gFM Business. To do this, simply switch to the view [Invoicing > Cash book > Bank entries]. Now select the function "Bank import". This opens a dialog in which the type of import and the appropriate financial account can be selected.
To import via clipboard from Bank X, select "Bank X from clipboard" as the import type. Now select the appropriate financial account and click on the button to confirm. [Import]. All bookings marked in Bank X have now been imported into gFM-Business and can be used. Account statements can be imported into gFM-Business in the same way using the online banking software MacGiro, which is also available for Mac OS X. gFM-Business also has an interface to the online banking software StarMoney and can import bookings in MT940 format, which is supported by most online banking programs.
Automatically identify payments
Once the account statements have been successfully imported into gFM Business, payments from invoice documents can be automatically identified and posted. To find a payment based on an invoice document, simply call up the open items in the main menu or in the invoice list.
Call up the invoice for which you want to identify a payment and select the function [Find payment]. If gFM-Business has found a suitable payment on a financial account, a corresponding message appears containing the posting text and the amount of the payment found.

Assign payments manually


Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.



